seriously i watched umpteen vedio regarding this, none of the vedio couldnt not able to understand but your vedio is very helpful for me. thanks for this
@@SpotlightImpact Of course - subscribed immediately and will share it with my university lab mates. We do a lot of psychometrics in the educational field so this is very useful.
Thanks for watching! Isn’t this trick a lifesaver?!? I hope you’ll subscribe and share with others - I’ll post other survey design/analysis videos in the future ❤️🙏🏻
Will add this to my list and create a video - I think we could do this 1) by transforming that column into a “1/0”, and then another pivot table for the text so you can see all of the responses as a list. More soon! 🤙🏻
Hi Gabriel! Here's one way I thought about working with this kind of data. It might not help 100% but could get you close! I hope it helps. ruclips.net/video/QGTDiGaEtd4/видео.html
Is there a way to set this up so it's a little more automated? For instance - I have a survey that is continuing to collect new responses and will be reanalyzing periodically. How can I streamline this so that I can just add the new data to the sheet without needing to re-do the later analysis steps?
That’s a bit trickier for select all that applies. In this case I think I’d probably use pivot tables - create one pivot table per column (item response). Then you can create a nicely formatted table you create pulling the data in from each pivot tables. I’ll make a video soon on how I’d do it. 👍🏻
Hi @Liz, just made this video on how I might think about doing this. Hope this helps! Thanks again for watching. I hope you'll subscribe and share with others. 🙏🙏 ruclips.net/video/7hw5AugiAw0/видео.html
Hi @ahmed I just posted a video on how I would analyze these kinds of data with other variables using the data filters and SUBTOTAL function. I hope this helps! ruclips.net/video/ewSpGByVR7c/видео.html
Thank you for your explanation but its not work for me and it said " there is problem with this formula .... and to type an apostrophe" what should i do?
@@shofaacademic hmmmm … I would go back and try to replicate the formula exactly - same cells and columns - step by step. Go Slowly and step by step. If you’d like send me the workbook you’re using I can take a look later today also. nick@spotlightimpact.com
If you’re using SPSS that’ll be a whole different bag. You’ll make each response option its own variable with 1 and 0 for the value. then under analyze you’ll select multiple response and add all of the new variables into that - then you can summarize them as a group.
Lots of ways! Framed bar charts are my favorite! But a regular bar chart would work well too, or a lollipop chart … likely many other ways too! spotlightimpact.com/blog/f/framed-bar-charts-so-chic
![How to analyze "Other" Write-In Survey Data in Excel 🔥 [VIEWER QUESTION]](http://i.ytimg.com/vi/QGTDiGaEtd4/mqdefault.jpg)
![How to analyze "Other" Write-In Survey Data in Excel 🔥 [VIEWER QUESTION]](/img/tr.png)
![Analyze Select-All-that-Apply Survey for Different Variables in Excel 🔥 [VIEWER QUESTION]](http://i.ytimg.com/vi/ewSpGByVR7c/mqdefault.jpg)
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Bundle Sale! Check out all of my data design templates and examples on Gumroad spotlightimpact.gumroad.com/l/ahkdm
Excellent. Just what I was desperately seraching for to analyse my 17-multi-choice column in Forms.
Thanks a lot.
Yay! I’m so glad it helped! I hope you’ll subscribe and share with others! 🙏🏻
Oh my goodness I have been looking for the answer to this FOREVER! Thank you!
Woohoo! Me too!! 🤣 this has been a godsend a time or two for me! Glad you liked it, I hope you’ll subscribe and share! 🙏🏻
seriously i watched umpteen vedio regarding this, none of the vedio couldnt not able to understand but your vedio is very helpful for me. thanks for this
Yay! I’m so glad it was helpful. I hope you’ll join, subscribe, or share 🙏🏻
Thank you for this - really helpful and easy to follow.
Yay! I’m glad you found it helpful! I hope you’ll share and subscribe 🙏🏻
Thank you so much! I looked everywhere and could not find a solution to this until I came across your video!!
Yay! I’m glad it worked. I hope you’ll subscribe and share. 🙏🏻
Wow 🥹 very well explained. Thanks 🙏🏾
Yay glad you liked it! I hope you’ll share and subscribe 🙏🏻
Thank you! Your videos have helped me tremendously in analyzing this data set.
Yay! I’m so glad they have helped! ❤️❤️✅
Thank you so so so much!
You’re welcome! I hope you’ll share and subscribe 🙏🏻
@@SpotlightImpact Done!
@@veganronswanson9000 🙏🏻🙏🏻🙏🏻
Very nice! Loved that transpose / copy / special... so easy
That so for watching I’m glad it was helpful! I hope you’ll subscribe and share! 🙏🏻
This is life saving!! Thank you so much.
Yay! I’m so glad it’s helpful. Definitely a cool trick. I hope you’ll subscribe to my channel and share with others 🙏🏻
@@SpotlightImpact Of course - subscribed immediately and will share it with my university lab mates. We do a lot of psychometrics in the educational field so this is very useful.
@@staceyc496 so cool! Thank you so much! I appreciate you! 🔥🙏🏻
Thst is awesome. Thanks so much!🎉
Thanks for watching! I hope you’ll share and subscribe 🙏🏻
thankyou excellent video
Thanks for watching. I hope you’ll subscribe and share 🙏🏻
You are the best. Thank you!
Thanks for watching! Isn’t this trick a lifesaver?!? I hope you’ll subscribe and share with others - I’ll post other survey design/analysis videos in the future ❤️🙏🏻
this is quite helpful but I have Large data and I need simple way to sort it in Excel exported from online survey from respondents
Are you using pivot tables to sort and summarize? If not you might consider that
ruclips.net/video/cklUxzFjN4I/видео.htmlsi=P70oMB7vwCXv-vJC
Thank you!!!!
You're most welcome! I hope you'll subscribe and share with others. 🙏
Thank You!!!!!! so much
You’re so welcome! I’m glad you watched. I hope you’ll subscribe and share with others 🙏🏻
Can you suggest a way to analyze option responses that include "Other" with a write-in box? They are exported as whatever the response to "Other" is.
Will add this to my list and create a video - I think we could do this 1) by transforming that column into a “1/0”, and then another pivot table for the text so you can see all of the responses as a list. More soon! 🤙🏻
Hi Gabriel! Here's one way I thought about working with this kind of data. It might not help 100% but could get you close! I hope it helps. ruclips.net/video/QGTDiGaEtd4/видео.html
Is there a way to set this up so it's a little more automated? For instance - I have a survey that is continuing to collect new responses and will be reanalyzing periodically. How can I streamline this so that I can just add the new data to the sheet without needing to re-do the later analysis steps?
That’s a bit trickier for select all that applies. In this case I think I’d probably use pivot tables - create one pivot table per column (item response). Then you can create a nicely formatted table you create pulling the data in from each pivot tables. I’ll make a video soon on how I’d do it. 👍🏻
Hi @Liz, just made this video on how I might think about doing this. Hope this helps! Thanks again for watching. I hope you'll subscribe and share with others. 🙏🙏 ruclips.net/video/7hw5AugiAw0/видео.html
Magic😀
Can you please do analysis of how Multiple response questions analyse with Region, gender any other question, Thank you
Will definitely do that! I’ll let you know when the video is posted.
Hi @ahmed I just posted a video on how I would analyze these kinds of data with other variables using the data filters and SUBTOTAL function. I hope this helps! ruclips.net/video/ewSpGByVR7c/видео.html
Thank you for your explanation but its not work for me and it said " there is problem with this formula .... and to type an apostrophe" what should i do?
If it asks you to type and apostrophe go ahead and try it. See if that works for you.
@@SpotlightImpact i tried but it didn’t work not sure if i put it in wrong location or not
@@shofaacademic hmmmm … I would go back and try to replicate the formula exactly - same cells and columns - step by step. Go Slowly and step by step. If you’d like send me the workbook you’re using I can take a look later today also. nick@spotlightimpact.com
@@SpotlightImpact Thank you for guidance, i will try it again slowly 🙏
It is awesome really, this support me
Thank you! I hope you’ll subscribe and share with others 🙏🏻
@@SpotlightImpact immediately subscribed
@@ahmedabdulahimahamud3272 awesome! Thank you! 🔥
Nice' but how we will use this into spss?
If you’re using SPSS that’ll be a whole different bag. You’ll make each response option its own variable with 1 and 0 for the value. then under analyze you’ll select multiple response and add all of the new variables into that - then you can summarize them as a group.
www.ibm.com/docs/en/spss-statistics/saas
Great! But how do present that in a graph?
Lots of ways! Framed bar charts are my favorite! But a regular bar chart would work well too, or a lollipop chart … likely many other ways too! spotlightimpact.com/blog/f/framed-bar-charts-so-chic
Framed Bar Chart - ruclips.net/video/aB_EI3-iHws/видео.htmlsi=GCFMRzZGMefnMPkX
Lollipop Chart - ruclips.net/video/vcYyGuzdsnI/видео.htmlsi=ix8o7qGucwsuiXjk
The formula you have posted is wrong. It should be =countif($B2,"*"&C$1&"*"). Hope that helps.
thanks for that catch John! I updated it in my description. 🙏
Terrible question / option set. You ask which they like "best" which implies a single choice should be selected.
You’re so right! thanks for your valuable insight. Good thing this was just a fake example, right Eric! 👍🏻