How to Analyze Survey Data Part 3 - Summarize with Pivot Tables and Charts

In this third part of the series we learn how to use Pivot Tables and formulas to analyze the multiple choice survey data. We also create a chart that shows the percentage of total responses for each item (choice) in the survey question.

00:00 Introduction
00:41 Pivot Tab les
05:42 Conclusion

[ianb]

Thank you for this useful video, Jon. What I'm looking for, though, is how to analyse ranked data from a customer survey - ie where, say, 20 customers put in ranked order their preferences about a certain product type. So I'd want to see how many customers ranked a certain option as 1st, 2nd, 3rd, 4th 5th. Using averages doesn't help because if some really liked a feature and others hated it, the average rank would be 3rd! So, I'm hoping to use the skills outlined in this video, to create something that shows more than just one choice (eg which drink with your breakfast), but has how many people ranked which feature in which place.

[alexatheoharides]

Do you have a video to show how to join multiple pivot tables? I'm having a hard time with this. I did a large survey that had a few fields with multiple check box selections and so now I need a way to easily analyze this data through pivot tables so I can make correlations to define my buyer personas.

[miriambonilla]

I always like your videos and thank you for sharing your knowledge.

[TheGoldDiggerPodcast]

Very helpful. I would love to see how you transform a survey monkey excel export document into a useable table. It is not easy to compare across surveys.

[sallydiaz]

Thank you so much, Jon! You have taught me so much with your tutorials. I liked and subscribed!

[kafetzou]

Thank you - this was very helpful. Is there a way to do this for more than one column at the same time?

[susannewalter]

Thank you very much for these videos, but please... a little bit slower... I have to pause every few seconds to replay to see what you did :)

[tristanquintus]

Very useful survey tutorial series - thanks Jon.

[kafetzou]

Also, my data is in a different format, because the survey was multiple answer, i.e. the respondents could choose more than one option for each question.

[dilbarzokirova]

Hi! Thank you very much for this video. However I didn't get the f4 thing, had to calculate separately for result. Do you have avideo where you show how to analyze questions with multiple answers?

[niyilivesinLondon-bmds]

Thanks so much very helpful tutorial video helped me a lot in analyzing data with multiple answers. Many thanks for sharing your knowledge

[SuperChica]

Question: in my case I would need to show how much % of the age range chose the particular response, its also a multiple response question. How can i do that? Please help

[osman]

Great video but in the Excel Pivot Tables playlist part 1 should probably come first.

[maxfueloon]

Great for excel business intelligence (statistics & visualisation made simple)

[asmitaaryan]

We do lots of data collection from surveys, would love to understand if you can teach me crosstabs as well

[jayesoteric]

I got the result from google form and then into Excel form raw...how do i go from there ? I need help

[mollylawrence]

What about if you have multiple questions with multiple, multiple choice answers

[birdsong]

Is there a way to compute the percentages with base = 20 automatically within the pivot table? I often do a lot of segmenting and subsetting the data (like gender, age), and it's cumbersome to compute totals for each subset over and over.

[gazbathdard]

Thanks Jon, another great video tutorial. How could I analyse a survey with for example 20 questions (the export places each question in a new column), and the answer for each entry (row) is either "Yes / No / Not Applicable"... Please can you help me out?

[yaolouis-hervedibi]

great videos ! How long should we waiting for the next videos ?