Hi! Thanks for this information. Say you had data that contained respondents age, gender and employment status - how would you test if there is an association between the cinema types and demographic factors? Would you combine the data and figure out the combined awareness level? And if so how would you go about doing that?
I don't know if there is a way to check if all demographic variables have a combined effect on something. There probably is something like multivariate regression analysis, and using one-hot encoding to change the categorical data into numerical, if you really want to know you might ask over at talkstats.com. Alternative you could just check each demographic variable to find out if for example Gender has an association with Awareness level. Then depending on the measurement level of Gender and Awarness select the appropriate technique. My companion website has a selection for any possible combination of two measurement levels (see peterstatistics.com). Hope this helps.
Dollar sign fixes a cell to prevent it from changing when you copy-paste. Its referred to as 'absolute cell referencing' in case you want to learn more about that. Note also I'm using a semicolon and not a comma, to separate parts of a formula, this might be different in your version.
Your capslock seems to be stuck. As mentioned in the other reply to a comment from you, it could be that you should use a comma and not a semi-colon. Otherwise copy-paste the formula you typed in in the comments and I can hopefully see what the mistake is.
Thanks a lot !!!! This really helped.
Hi! Thanks for this information. Say you had data that contained respondents age, gender and employment status - how would you test if there is an association between the cinema types and demographic factors? Would you combine the data and figure out the combined awareness level? And if so how would you go about doing that?
I don't know if there is a way to check if all demographic variables have a combined effect on something. There probably is something like multivariate regression analysis, and using one-hot encoding to change the categorical data into numerical, if you really want to know you might ask over at talkstats.com.
Alternative you could just check each demographic variable to find out if for example Gender has an association with Awareness level. Then depending on the measurement level of Gender and Awarness select the appropriate technique. My companion website has a selection for any possible combination of two measurement levels (see peterstatistics.com). Hope this helps.
Thanks, this helped alot
Glad it helped
Thank you very much. I want to know how i can do cross tabulation with multiple response question in excel
you would probably need to use the 'countifs' function, to count those matching the specific value of both variables.
Thank you sir
You're welcome, glad the video helped. Good luck with your research/study/analysis
why did you use dollar sign? Mine is not working, eh
Dollar sign fixes a cell to prevent it from changing when you copy-paste. Its referred to as 'absolute cell referencing' in case you want to learn more about that.
Note also I'm using a semicolon and not a comma, to separate parts of a formula, this might be different in your version.
I didn't understand the way you insert the formula
I insert the formula by typing it in the cell, but perhaps that's not what you meant. Could you perhaps then clarify your question?
@@stikpet I TRIED PUTTING DOLLAR SIGN, BUT IT'S NOT WORKING. iT KEEPS SAYING "THERE'S A PROBLEM WITH THE FORMULA".
Your capslock seems to be stuck. As mentioned in the other reply to a comment from you, it could be that you should use a comma and not a semi-colon. Otherwise copy-paste the formula you typed in in the comments and I can hopefully see what the mistake is.