This is very helpful - thank you! I've found several of your videos very useful so far! Thanks very much! This may be a dim question, but I'm wndering if it would be possible to utilise this table you generate at the end of this video to execute a chi-squared association test between a multiple response variable and another nominal variable? i.e. in the case featured in this video, is it possible to use a chi-squared test to see if there is an association between membership and experience(s) had. Or would this only work if testing for association between each individual answer option (i.e. treating each individual answer option as a dichotomous selected/not-selected question)? I hope this makes sense - let me know if you need me to clarify further :)
I believe your second option is what would be appropriate for the chi-square test. I don’t think this can be run on a dataset where there are overlapping values - the question would need to be single response as opposed to multiple response. great question! ❤
I didn't know the double-click trick to un-hide filtered rows!! So appreciate getting to watch these, Nick!
Yay! I’m so glad you found it useful! I love discovering new tricks in excel so much! 💪🏻
Thank you so much, you can't imagine how this supported me. Thank you
Awesome! I’m so glad to hear it!
Excellent
Thank you so much for watching! I hope you’ll subscribe and share with others 🙏🏻
Thanks very much
You’re welcome. I hope it was helpful 🙏🏻
This is very helpful - thank you! I've found several of your videos very useful so far! Thanks very much!
This may be a dim question, but I'm wndering if it would be possible to utilise this table you generate at the end of this video to execute a chi-squared association test between a multiple response variable and another nominal variable? i.e. in the case featured in this video, is it possible to use a chi-squared test to see if there is an association between membership and experience(s) had.
Or would this only work if testing for association between each individual answer option (i.e. treating each individual answer option as a dichotomous selected/not-selected question)? I hope this makes sense - let me know if you need me to clarify further :)
I believe your second option is what would be appropriate for the chi-square test. I don’t think this can be run on a dataset where there are overlapping values - the question would need to be single response as opposed to multiple response. great question! ❤
@@SpotlightImpact thanks for your thoughts :)
Excellent
Thanks for watching! I hope you’ll subscribe and share with others! 🙏🏻