Categories

Help with analyzing data from survey?

Ramit Sethi · August 28th, 2007

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.

Quiz: What is your earning potential? Choose the answer you agree with the most
View Results

Do you know your actual earning potential?

Get started with the Earning Potential quiz. Get a custom report based on your unique strengths, and discover how to start making extra money — in as little as an hour.

Start The Quiz

Takes 3 min

11 Comments

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

  2. Gary Haran

    Can the data be exported in csv format?

  3. Ramit Sethi

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

  4. rob rubin

    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

    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

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

  7. Roland Studer

    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

    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

    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

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

  11. Pivot tables, my friend.