Help with analyzing data from survey?

August 28, 2007 · 11 comments

I have a favor to ask: I want to present the data from last week’s survey, but Wufoo doesn’t make it easy. I have over 1,200 records in Excel. If anyone has Excel foo and some time to help analyze the data so I can post the results, please get in touch. I’m looking for a clean HTML export of the data analysis so I can just post the results.

[Update]: Wow, thanks. I got a ton of offers for help and I’m sorting through them now.

Previous post:

Next post:

11 comments

Leave a comment
1 dimes August 28, 2007 at 10:08 am

Wow, that’s a LOT of responses.
What’s Excel foo? Some Wufoo/Excel blend?

2 Gary Haran August 28, 2007 at 10:21 am

Can the data be exported in csv format?

3 Ramit Sethi August 28, 2007 at 10:24 am

Yep, I have the data in Excel and CSV format.

4 rob rubin August 28, 2007 at 11:45 am

If you want to send me an Excel or CSV file, I can import it into SPSS and do some analysis for you (my expertise actually). I’ll return it to you in excel so you can post it anyway you want.

Rob

5 Joshua Gruber August 28, 2007 at 1:11 pm

Oooh. I was going to volunteer but Rob pulled out the big guns. I’ll bet he’ll give you scatter charts and all sorts of fun stuff.

6 Minimum Wage August 28, 2007 at 2:55 pm

Do people still use SPSS? That is so ’70s…

7 Roland Studer August 28, 2007 at 2:57 pm

Ah, I have volunteered, but I hadn’t seen rob’s post. But you don’t really wanna do stuff like this in Excel. SPSS or other statistical are far more suited for such tasks.

8 Roland Studer August 28, 2007 at 3:02 pm

Yeah people still use SPSS, but the product hasn’t really evolved a lot (from version 11 to 15), and the mac experience has always been a poor one. Sadly it is still the standard at our university.

9 Aaron Hernandez August 29, 2007 at 2:05 pm

two words pivot tables. A bit of a learning curve , but otherwise amazing and easy use. Just make sure you have titles for every field.

10 mikesyr August 29, 2007 at 4:10 pm

I’d take Rob’s offer. This requires either SPSS, SAS or Stata. Excel is not gonna cut it. At least not easily. :)

11 pj August 30, 2007 at 12:13 pm

Pivot tables, my friend.

Comments on this entry are closed.

Previous post:

Next post: