Analyzing data using surveys in Google Docs
May 17, 2012 12:50 PM   Subscribe

We conducted a survey using Google Docs Spreadsheets. Unfortunately. Now we would like an easy way to analyze the data. How?

I am part of a team that recently conducted a survey using Google Docs. The responses to the survey were dumped into what looks like Google Docs' version of Excel. Is there an easy hack so that we can make Google Docs do something similar to SurveyMonkey's Analyze Results feature? Or do I just need to suck it up and finally learn Excel and pivot tables? If the latter, any recommendations about resources for learning about pivot tables?
posted by stellaluna to Computers & Internet (3 answers total) 1 user marked this as a favorite
Yes, you can. In your spreadsheet, choose the Form menu, then "Show summary of responses."
posted by zvs at 1:02 PM on May 17, 2012 [1 favorite]

You. You are amazing. Thank you!
posted by stellaluna at 3:01 PM on May 17, 2012

Pivot tables are a quick, straightforward tool. Though the summary of response are just that, a summary. May be helpful to use the cross tab functions in pivot tables to really get into the data.
posted by psergio at 3:09 PM on May 17, 2012

« Older Cheapest, fastest internet in the emerald city?   |   Advice on setting up a VPN Newer »
This thread is closed to new comments.