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. th-cam.com/video/QGTDiGaEtd4/w-d-xo.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. 🙏🙏 th-cam.com/video/7hw5AugiAw0/w-d-xo.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! th-cam.com/video/ewSpGByVR7c/w-d-xo.html
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.
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
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
![Viewer Q!🙋♂️ How to analyze "Other" Write-In Survey Data in Excel 🔥 [SURVEY TIPS 💻]](http://i.ytimg.com/vi/QGTDiGaEtd4/mqdefault.jpg)
![Viewer Q!🙋♂️ How to analyze "Other" Write-In Survey Data in Excel 🔥 [SURVEY TIPS 💻]](/img/tr.png)
![Viewer Q!🙋♂️ Analyze Select-All-that-Apply Survey for Different Variables in Excel 🔥 [EXCEL TIPS]](http://i.ytimg.com/vi/ewSpGByVR7c/mqdefault.jpg)
Bundle Sale! Check out all of my data design templates and examples on Gumroad spotlightimpact.gumroad.com/l/ahkdm
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 🙏🏻
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! 🙏🏻
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 🙏🏻
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! 🙏🏻
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. 🙏🏻
Thank you! Your videos have helped me tremendously in analyzing this data set.
Yay! I’m so glad they have helped! ❤️❤️✅
Wow 🥹 very well explained. Thanks 🙏🏾
Yay glad you liked it! I hope you’ll share and subscribe 🙏🏻
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! 🙏🏻
Thank you so so so much!
You’re welcome! I hope you’ll share and subscribe 🙏🏻
@@SpotlightImpact Done!
@@veganronswanson9000 🙏🏻🙏🏻🙏🏻
Thst is awesome. Thanks so much!🎉
Thanks for watching! I hope you’ll share and subscribe 🙏🏻
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! 🔥🙏🏻
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 ❤️🙏🏻
Thank You!!!!!! so much
You’re so welcome! I’m glad you watched. I hope you’ll subscribe and share with others 🙏🏻
thankyou excellent video
Thanks for watching. I hope you’ll subscribe and share 🙏🏻
Thank you!!!!
You're most welcome! 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. th-cam.com/video/QGTDiGaEtd4/w-d-xo.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. 🙏🙏 th-cam.com/video/7hw5AugiAw0/w-d-xo.html
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! 🔥
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! th-cam.com/video/ewSpGByVR7c/w-d-xo.html
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
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 🙏
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 - th-cam.com/video/aB_EI3-iHws/w-d-xo.htmlsi=GCFMRzZGMefnMPkX
Lollipop Chart - th-cam.com/video/vcYyGuzdsnI/w-d-xo.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! 👍🏻