How to Use Pivot Tables for Survey Data! 🔥 [EXCEL TIPS]

[@yerfillag]

THANK YOU!! I'm working with pivot tables for the first time and have been struggling to find instructions on how to best use it with text-only values

[@SpotlightImpact]

Yay! I'm glad you liked it. I hope you'll share and subscribe.

[@karenwillard-xh5fb]

Thank you for this video! You helped me get some attendance data sorted for work. I really appreciate it!

[@SpotlightImpact]

Yay! I’m so glad it helped. I hope you’ll share and subscribe 🙏🏻

[@bazar4764]

Hi Nick! I have found all your videos so so helpful. There is no one like you on KZbin that makes data analysis make so much more sense. One question I have I am finding impossible to find an answer to is creating a pivot table / cross tabulating two data points with multiple responses. E.g. If you had a survey about peoples goals and peoples pain points with both questions having multiple response answers. Do you have any experience in creating a pivot table with two multiple choice questions e.g. to find out if there are any correlations between peoples goals and pain points?

[@SpotlightImpact]

Thanks Bazar! I hope you’ll subscribe and share! This is a great question and one I’m not sure I have a great answer to yet. Pivot tables with questions that are multiple select or ‘select all that apply’ are tough. I usually have to make a separate pivot table for each individual response option. You could try doing something like this (video link below) but it’s not as great as an actual pivot table that will be updated directly from the data source. kzbin.info/www/bejne/m6i2oXp4rruFbcU

[@bazar4764]

@@SpotlightImpact Hi Nick, most definitely subscribed already :) Okay thanks for the information. I have asked the question around quite a bit and I think from what I understand it's difficult to do within Excel and needs external software that's a bit more advanced such as SPSS to extract correlations. Nonetheless, I will check out the video you suggested and see if I can make any progress. Thanks for the reply and keep up the good work/content!

[@SpotlightImpact]

@@bazar4764 yep SPSS might be your best bet! Try PSPP the free version too! www.gnu.org/software/pspp/