Cross-tabulation of multiple response survey data in Excel Pivot Tables

[@MSurveyPoint]

Connect with me if you need support on the following services Email: [e-mail] Book appointment here 👉 calendar.app.google/MMasAbZPDuwCCux76 1. Survey questionnaire design 2. Online survey scripting 3. Survey data Analysis 4. Research report writing 5. Data analysis in Excel 6. Survey Dashboard in Excel 7. Survey Dashboard in Power Bi The scope of my services includes but not limited to the areas of Market Research, Customer Experience Research, Product Research, User Experience Research, Employee Engagement Surveys, NPS, CSAT & Voice of the customer, Monitoring & Evaluation, etc.

[@faithngoya3883]

I cant tell you how you have left me smiling and awed when I watch your videos. Its so easy to understand things I thought were tough when I listen to you do this! Your videos are very meticulous, clearly audible and great step by step guide. You are great!🤩🤗Thank you!❤❤

[@MSurveyPoint]

I'm so glad this helps.

[@Natnatnatnatnatnatnat]

Thank you very much for this. It is very useful for someone with no experience in working with survey data! Please keep making more 🙏🏻

[@MSurveyPoint]

​@@Natnatnatnatnatnatnat Thank you for the encouragement 🙏

[@NicoleNotarioRisk]

Thanks for this great tutorial! It was so easy to understand.

[@Laura-hw1bv]

Fantastic video! I've been struggling to combine my data in one table and this is exactly what I've been looking for. Bravo sir 👏

[@MSurveyPoint]

Thanks for the feedback, Laura.

[@astarinip5470]

Thanks for this!!! Easy to follow and clear explanation 😊

[@ahmedabdulahimahamud3272]

All your videos are helpful for me as I work assessments, from the start I found your channel I have stopped using SPSS, by now I only use excel sheet thank you so much

[@MSurveyPoint]

Many thanks for the feedback. We are happy you find this helpful. More coming up on survey data analysis using Pivot Tables

[@lawrencekazibwe9751]

Thanks alot boss,it has been very informative 🎉

[@MSurveyPoint]

@@lawrencekazibwe9751 Glad this helped. Thanks for the feedback

[@waleadeniji6959]

you are on point... exactly what i am trying to achieve....

[@MSurveyPoint]

Thank you. We happy this helps. Kindly subscribe to support us

[@PoulamiDatta-fm1oq]

can I do chi square of this multiple response survey data ??

[@MSurveyPoint]

Yes. However, here the standard Chi-Square test is not appropriate since there is within group dependency as respondents had the option to select more than one item in each of the multiple response questions. Marginal Chi-Square test is recommended in this case.

[@jessiki5711]

your videos are great! but I have one issue, if I go to "close & load to" it only shows me in the window of Import Data "Table" and "Only Create Connection". How can I get the option for "Pivot Table Report"?

[@MSurveyPoint]

@@jessiki5711 This could happen depending on the Excel version. You can still create Pivot Tables from there anyway. However, with few additional steps From there.... Select create connect and check; add to data model. .. wait for it to load Now proceed as follows Insert>Pivot Tables>External connect>Select Unpivoted or data table you loaded>>add>Ok Then create your pivot table

[@vickypereya8238]

Hi! great video but im having trouble understanding why when I unpivot, only one of the columns of the answers is left. Could you please explain that to me? I want both answers to remain

[@MSurveyPoint]

Great to know this helps. Please check if you have the responses of the columns you unpivoted in that single column. Also recheck if you selected all the columns you want to unpivot. Ideally, unpivoting regroups the responses in each of the columns into the values column and the column names into the attribute column.

[@vickypereya8238]

@@MSurveyPoint I did thanks! Another question if its not too much to ask, I closed the right window where the values, axis x y etc was, where I had all the info of the questions that I had unpivoted. I did some graphs and it was working but now it closed and I cant open it again. Coould you please help? Thank you again!!

[@MSurveyPoint]

@@vickypereya8238 Happy to hear it worked out Click anywhere in one of the pivot tables you have generated. >right-click and scroll down to the bottom. >select "Show Field list" at the bottom You can always hide/show the Field list pane that way. Please do support me by subscribing.

[@vickypereya8238]

Of course @@MSurveyPoint thank you!!!! Im sorry, a couple more questions. I have, like in your video, multiple questions (with multiple answers) I want to do other tables but when I copy the table it doesnt give me another pivot table, with the values on the right, it only copies the table. And as I am creating graphs from each table if I do it all on the same table it erases the last tables. Also, what would you do in questions where its order from most important to least important? I have in the "data base" table columns divided by answers, the first column is the most important, the one on the right the second most important etc. What would you do? If you tell me its ok, Ill write you on email. Thank yu again! ur videos are great,I will share them

[@MSurveyPoint]

Hi Vicky Pereya I think the best will be to catch up on a call so I can get to understand the data better and the issue you need assistance with. Thanks Please pick a time here that works for you: 👉 calendar.app.google/MMasAbZPDuwCCux76

[@MSurveyPoint]

Check out these videos on multiple response survey data 1. How to Analyze Space-separated Multiple response Survey Data in Excel Pivot Table: kzbin.info/www/bejne/gHvNfmWDpbxjotk 2. How to analyze comma-separated multiple choice survey data in Pivot Table: kzbin.info/www/bejne/oZOmpWB6bMdppck 3. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table: kzbin.info/www/bejne/i57En2WHadGUeKc 4. How to Analyze 1/0 coded Multiple Response Survey Data in Excel Pivot Table: kzbin.info/www/bejne/oZXIhWeFZZaho7c 5. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table kzbin.info/www/bejne/roa8Y6WAmcmHaac 6. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table kzbin.info/www/bejne/lZbCg4tqmpeMa9k

[@chandramohan1418]

Plprovide files.thankyu

[@MSurveyPoint]

@ubaidillahmuhammad20 Here is the sample data I used in all the videos on multiple response survey data analysis. docs.google.com/spreadsheets/d/1JC1NdgHubItR0vOKEP8mFiORdbNfILvu/edit?usp=sharing&ouid=117355798969062583983&rtpof=true&sd=true