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?
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?
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
posted by psergio at 3:09 PM on May 17, 2012
This thread is closed to new comments.
posted by zvs at 1:02 PM on May 17, 2012 [1 favorite]