How to Analyze Select-All-That-Apply Survey Questions in Excel ✅ [MS FORMS!]

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ต.ค. 2024

ความคิดเห็น • 68

  • @SpotlightImpact
    @SpotlightImpact  3 หลายเดือนก่อน +2

    Bundle Sale! Check out all of my data design templates and examples on Gumroad spotlightimpact.gumroad.com/l/ahkdm

  • @007epsifa.a7
    @007epsifa.a7 2 หลายเดือนก่อน +1

    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
      @SpotlightImpact  2 หลายเดือนก่อน +1

      Yay! I’m so glad it was helpful. I hope you’ll join, subscribe, or share 🙏🏻

  • @Kris10limon
    @Kris10limon ปีที่แล้ว +1

    Oh my goodness I have been looking for the answer to this FOREVER! Thank you!

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      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! 🙏🏻

  • @CarolineMagee-i6z
    @CarolineMagee-i6z 2 หลายเดือนก่อน +1

    Thank you for this - really helpful and easy to follow.

    • @SpotlightImpact
      @SpotlightImpact  2 หลายเดือนก่อน +1

      Yay! I’m glad you found it helpful! I hope you’ll share and subscribe 🙏🏻

  • @madslundberg6328
    @madslundberg6328 ปีที่แล้ว +4

    Excellent. Just what I was desperately seraching for to analyse my 17-multi-choice column in Forms.
    Thanks a lot.

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      Yay! I’m so glad it helped! I hope you’ll subscribe and share with others! 🙏🏻

  • @pathofclouds85
    @pathofclouds85 ปีที่แล้ว +1

    Thank you so much! I looked everywhere and could not find a solution to this until I came across your video!!

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +2

      Yay! I’m glad it worked. I hope you’ll subscribe and share. 🙏🏻

  • @loisndungu4805
    @loisndungu4805 ปีที่แล้ว +1

    Thank you! Your videos have helped me tremendously in analyzing this data set.

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      Yay! I’m so glad they have helped! ❤️❤️✅

  • @MsAngulu
    @MsAngulu ปีที่แล้ว +1

    Wow 🥹 very well explained. Thanks 🙏🏾

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +2

      Yay glad you liked it! I hope you’ll share and subscribe 🙏🏻

  • @nkabessa
    @nkabessa ปีที่แล้ว +1

    Very nice! Loved that transpose / copy / special... so easy

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว

      That so for watching I’m glad it was helpful! I hope you’ll subscribe and share! 🙏🏻

  • @veganronswanson9000
    @veganronswanson9000 14 วันที่ผ่านมา +1

    Thank you so so so much!

    • @SpotlightImpact
      @SpotlightImpact  14 วันที่ผ่านมา +2

      You’re welcome! I hope you’ll share and subscribe 🙏🏻

    • @veganronswanson9000
      @veganronswanson9000 14 วันที่ผ่านมา +1

      @@SpotlightImpact Done!

    • @SpotlightImpact
      @SpotlightImpact  13 วันที่ผ่านมา +1

      @@veganronswanson9000 🙏🏻🙏🏻🙏🏻

  • @MrPKORC
    @MrPKORC 10 หลายเดือนก่อน +1

    Thst is awesome. Thanks so much!🎉

    • @SpotlightImpact
      @SpotlightImpact  10 หลายเดือนก่อน +1

      Thanks for watching! I hope you’ll share and subscribe 🙏🏻

  • @staceyc496
    @staceyc496 ปีที่แล้ว +1

    This is life saving!! Thank you so much.

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +2

      Yay! I’m so glad it’s helpful. Definitely a cool trick. I hope you’ll subscribe to my channel and share with others 🙏🏻

    • @staceyc496
      @staceyc496 ปีที่แล้ว +1

      @@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.

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      @@staceyc496 so cool! Thank you so much! I appreciate you! 🔥🙏🏻

  • @katherineruark4401
    @katherineruark4401 ปีที่แล้ว +1

    You are the best. Thank you!

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      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 ❤️🙏🏻

  • @nhatguy5543
    @nhatguy5543 ปีที่แล้ว +1

    Thank You!!!!!! so much

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      You’re so welcome! I’m glad you watched. I hope you’ll subscribe and share with others 🙏🏻

  • @markmyers514
    @markmyers514 ปีที่แล้ว +1

    thankyou excellent video

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      Thanks for watching. I hope you’ll subscribe and share 🙏🏻

  • @ketop
    @ketop ปีที่แล้ว +1

    Thank you!!!!

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      You're most welcome! I hope you'll subscribe and share with others. 🙏

  • @gabriels6717
    @gabriels6717 ปีที่แล้ว +2

    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.

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      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! 🤙🏻

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      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

  • @lizmartin3790
    @lizmartin3790 ปีที่แล้ว +1

    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?

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +2

      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. 👍🏻

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +2

      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

  • @ahmedabdulahimahamud3272
    @ahmedabdulahimahamud3272 ปีที่แล้ว +1

    It is awesome really, this support me

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      Thank you! I hope you’ll subscribe and share with others 🙏🏻

    • @ahmedabdulahimahamud3272
      @ahmedabdulahimahamud3272 ปีที่แล้ว +1

      @@SpotlightImpact immediately subscribed

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      @@ahmedabdulahimahamud3272 awesome! Thank you! 🔥

  • @tekaah
    @tekaah ปีที่แล้ว +1

    Magic😀

  • @ahmedabdulahimahamud3272
    @ahmedabdulahimahamud3272 ปีที่แล้ว +1

    Can you please do analysis of how Multiple response questions analyse with Region, gender any other question, Thank you

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      Will definitely do that! I’ll let you know when the video is posted.

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +2

      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

  • @shahanapeeroo991
    @shahanapeeroo991 2 หลายเดือนก่อน +1

    Nice' but how we will use this into spss?

    • @SpotlightImpact
      @SpotlightImpact  2 หลายเดือนก่อน +1

      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.

    • @SpotlightImpact
      @SpotlightImpact  2 หลายเดือนก่อน +1

      www.ibm.com/docs/en/spss-statistics/saas

  • @shofaacademic
    @shofaacademic หลายเดือนก่อน +1

    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?

    • @SpotlightImpact
      @SpotlightImpact  หลายเดือนก่อน +2

      If it asks you to type and apostrophe go ahead and try it. See if that works for you.

    • @shofaacademic
      @shofaacademic หลายเดือนก่อน +1

      @@SpotlightImpact i tried but it didn’t work not sure if i put it in wrong location or not

    • @SpotlightImpact
      @SpotlightImpact  หลายเดือนก่อน +2

      @@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

    • @shofaacademic
      @shofaacademic หลายเดือนก่อน +1

      @@SpotlightImpact Thank you for guidance, i will try it again slowly 🙏

  • @Olecram_Spartan_Gaming
    @Olecram_Spartan_Gaming 10 หลายเดือนก่อน +1

    Great! But how do present that in a graph?

    • @SpotlightImpact
      @SpotlightImpact  10 หลายเดือนก่อน +1

      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

    • @SpotlightImpact
      @SpotlightImpact  10 หลายเดือนก่อน +1

      Framed Bar Chart - th-cam.com/video/aB_EI3-iHws/w-d-xo.htmlsi=GCFMRzZGMefnMPkX

    • @SpotlightImpact
      @SpotlightImpact  10 หลายเดือนก่อน +1

      Lollipop Chart - th-cam.com/video/vcYyGuzdsnI/w-d-xo.htmlsi=ix8o7qGucwsuiXjk

  • @JohnDanenbarger
    @JohnDanenbarger ปีที่แล้ว +1

    The formula you have posted is wrong. It should be =countif($B2,"*"&C$1&"*"). Hope that helps.

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +2

      thanks for that catch John! I updated it in my description. 🙏

  • @Eric.Atchison
    @Eric.Atchison ปีที่แล้ว +1

    Terrible question / option set. You ask which they like "best" which implies a single choice should be selected.

    • @SpotlightImpact
      @SpotlightImpact  ปีที่แล้ว +1

      You’re so right! thanks for your valuable insight. Good thing this was just a fake example, right Eric! 👍🏻