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.
Hello, thank you so much for this useful tutorial. But for me I have faced one challenge that when I do all the process and paths you have gone, finally I get all responses having the same counts
@@denisdeusdedith5849 Sorry to hear it doesn't seem to work for you. I suggest you review the structure of your data, and analytical steps. Also, as you have booked my calendar, I will take a closer look at the data with you and assist appropriately.
Hi Kizito. Thanks for the question. Yes. I have covered that for 3 multiple response question in this video. In such cases, make sure to delete columns you do not need for analysis (or data segmentation) in each unpivoted table to manage the model size, especially for large sample sizes. ruclips.net/video/WX5hLOfC1R0/видео.html
Check out these videos on multiple response survey data 1. How to Analyze Space-separated Multiple response Survey Data in Excel Pivot Table: ruclips.net/video/JJjM2MpW0lw/видео.html 2. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table: ruclips.net/video/Uman2Q4laBE/видео.html 3. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table ruclips.net/video/xUY2rJddT3E/видео.html 4. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table ruclips.net/video/_e_RX4e2Y5w/видео.html
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.
Hello, thank you so much for this useful tutorial. But for me I have faced one challenge that when I do all the process and paths you have gone, finally I get all responses having the same counts
@@denisdeusdedith5849
Sorry to hear it doesn't seem to work for you. I suggest you review the structure of your data, and analytical steps.
Also, as you have booked my calendar, I will take a closer look at the data with you and assist appropriately.
Thank you so so much, it is very helpful
Glad it was helpful!
Very very awesome, this is a simple way of analyzing multiple response, thank you so much, kindly include with other variables
Hi Ahmed. That is now covered here ruclips.net/video/WX5hLOfC1R0/видео.html
This is what I have been waiting for.
So helpful, thank you so much
Is the close and load to pivot an option available only on certain devices?
Hi Juliana
You should see that once you load your data to power query.
Not sure. But should be available in Excel 2016 and later
So does this mean if i have say 5 multiple response questions i'll need to follow procedure for each one of them and do them separately?
Hi Kizito.
Thanks for the question. Yes.
I have covered that for 3 multiple response question in this video. In such cases, make sure to delete columns you do not need for analysis (or data segmentation) in each unpivoted table to manage the model size, especially for large sample sizes.
ruclips.net/video/WX5hLOfC1R0/видео.html
@@MSurveyPoint Okay, understood
Your help is much appreciated.
Check out these videos on multiple response survey data
1. How to Analyze Space-separated Multiple response Survey Data in Excel Pivot Table:
ruclips.net/video/JJjM2MpW0lw/видео.html
2. How to Analyze Columns-separated Multiple Response Survey Data in Excel Pivot Table:
ruclips.net/video/Uman2Q4laBE/видео.html
3. How to Analyze TRUE/FALSE coded Multiple Response Survey Data in Excel Pivot Table
ruclips.net/video/xUY2rJddT3E/видео.html
4. How to Analyze Yes/No coded Multiple Response Survey Data in Excel Pivot Table
ruclips.net/video/_e_RX4e2Y5w/видео.html
Cross-tabulation of multiple response survey data in Excel Pivot Tables
ruclips.net/video/WX5hLOfC1R0/видео.html