Cross-tabulation of multiple response survey data in Excel Pivot Tables
ฝัง
- เผยแพร่เมื่อ 12 ก.ย. 2024
- Check out these videos on multiple response survey data
1. How to Analyze Space-separated Multiple response Survey Data in Excel Pivot Table:
• How to Analyze Space-s...
2. How to analyze comma-separated multiple choice survey data in Pivot Table:
• How to analyze comma-s...
3. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table:
• How to Analyze Columns...
4. How to Analyze 1/0 coded Multiple Response Survey Data in Excel Pivot Table:
• How to Analyze 1/0 cod...
5. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table
• How to Analyze TRUE/F...
6. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table
• How to Analyze Yes/No ...
Connect with me if you need support on the following services
Email: msurveypoint@gmail.com
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.
Thank you very much for this. It is very useful for someone with no experience in working with survey data! Please keep making more 🙏🏻
@@Natnatnatnatnatnatnat
Thank you for the encouragement 🙏
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!❤❤
I'm so glad this helps.
Check out these videos on multiple response survey data
1. How to Analyze Space-separated Multiple response Survey Data in Excel Pivot Table:
th-cam.com/video/JJjM2MpW0lw/w-d-xo.html
2. How to analyze comma-separated multiple choice survey data in Pivot Table:
th-cam.com/video/kbCt-D7b6og/w-d-xo.html
3. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table:
th-cam.com/video/Uman2Q4laBE/w-d-xo.html
4. How to Analyze 1/0 coded Multiple Response Survey Data in Excel Pivot Table:
th-cam.com/video/kdeT4O01nmU/w-d-xo.html
5. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table
th-cam.com/video/xUY2rJddT3E/w-d-xo.html
6. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table
th-cam.com/video/_e_RX4e2Y5w/w-d-xo.html
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 👏
Thanks for the feedback, Laura.
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
Many thanks for the feedback. We are happy you find this helpful. More coming up on survey data analysis using Pivot Tables
Thanks alot boss,it has been very informative 🎉
@@lawrencekazibwe9751
Glad this helped.
Thanks for the feedback
Thanks for this great tutorial! It was so easy to understand.
Thanks for this!!! Easy to follow and clear explanation 😊
you are on point... exactly what i am trying to achieve....
Thank you. We happy this helps.
Kindly subscribe to support us
can I do chi square of this multiple response survey data ??
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.
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
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.
@@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!!
@@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.
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
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
Plprovide files.thankyu
@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