Search code examples
excelevaluationsurvey

Best way to evaluate a survey

I need to evaluate a survey that was made with visitors of an exhibition. Questions were about demographic details of the visitors and how they experienced the exhibition (questions about quality, whether they found it interesting, ...)

Now I don't have to just take each question and make a bar or pie chart from the data, the idea is to filter the data to have results like: How did people under 25 find the exhibition? Were people from abroad as satisfied as people from the region?

My question: Is there a better solution/tool than storing the data in an Excel sheet and building interactive charts with it?

Solution

  • Not sure if you are already aware of them, but one solution would be to use PivotTables or PivotCharts in Excel. With a PivotTable or PivotChart you can slice and dice the data anyway you need to filter the data and view the results.

    There's information available at http://office.microsoft.com/en-us/excel-help/overview-of-pivottable-and-pivotchart-reports-HP010177384.aspx.