Excel - Pearson chi square test of independence
HTML-код
- Опубликовано: 11 сен 2024
- Instructional video on how to perform a Pearson Chi-square test of independence using Excel.
Example file at: bit.ly/3Czm9wd
Companion website at PeterStatistic...
Donation welcome at Patreon: www.patreon.co...
Simplest with effective teaching approach
thanks, that's what I'm aiming for. The videos are more for those who already know what they want but not how to get it. On my website I try to explain (still short) a bit more on what each test actually does. Glad it helped.
Marry me. You were my beacon of light at the end of this long-ass day of confusion...
:-) thanks. Glad it helped.
your voice is so soothing
Thank you for this! You've just saved my dissertation!!!!
Glad I could help!
A very informative, illustrative and effective video... Thank you for creating such video.. keep making
Thank you for this. It was really helpful.
Glad it helped.
On a side note, RUclips has cancelled my partner program since I don't have enough subscribers (currently around 927, should be 1000 😞), so it would really help if you subscribe (and all your friends) 😉
very explanatory video. thank you very much for this!
Thanks for the positive feedback. Glad it helped.
On a side note, RUclips has cancelled my partner program since I don't have enough subscribers (currently around 878, should be 1000 😞), so it would really help if you subscribe (and all your friends) 😉
@@stikpet sure no problem
Thank you so much. Keep Making
Thank you, I will
great tutorial! thank you
Thanks for the positive feedback. Glad it helped.
On a side note, RUclips has cancelled my partner program since I don't have enough subscribers (currently around 927, should be 1000 😞), so it would really help if you subscribe (and all your friends) 😉
Thank you kind sir, JMP was giving me hell
glad the video helped. I vaguely remember taking an online course once with JMP but am not very familiar with it.
Hi! I like your videos. (Subbed!)
I only have questions regarding the formula for computing the 'Expected' table:
Q: Why is your expectation computed as Ri*Ci/N?
Q: Is this formula fixed Or it can arbitrary? Meaning I have other expectations.
Q: What distribution does that formula follow?
Glad you enjoy the video and thanks for the sub.
The formula for the expected count is nicely explained on this site: www.thejuliagroup.com/blog/why-chi-square-is-expecting-the-expected-value/
That should answer your first question.
The formula itself is always the same, but I'm not sure if you can actually also just ignore the formula and type in your own expected values. I would actually think so, but I am not sure (sorry).
The expected values themselves do not have a distribution to my knowledge, the chi-square values have a chi-square distribution.
Hope this clarifies a bit.
@3:50 , what exactly does the p value tell here? and I DO NOT MEAN only "less than 0.05 so it is significant". I mean the actual meaning of it, which group is significantly different than the other? If this is the case, is there a post hoc test to separate the group, for example using letters... a, b , c etc..
My videos are often more on how to get a specific result, and don't go into if you even should and explaining what the results mean. For that I use the website slightly more, and perhaps will also create videos on that in the future. Have a look at peterstatistics.com/CrashCourse/3-TwoVarUnpair/NomNom/NomNom-2a-Test.html
In general the significance is the probability of a result (in this case that chi-square value) as in the sample , or even more extreme, if the assumption about the population would be true. With this test the assumption is that the two variables are independent. So if this chance is very low, that assumption is most likely incorrect, and the two variables have an influence on each other.
oh, additionally on the site you'll also see a section on the left on post-hoc test, since indeed you'll probably want to know which groups are different.
what does your result mean? what does a significance of 0 mean? pls help
The formal answer is: the chance of a chi-square value as in the sample, or even more extreme, if the assumption about the population would be true is almost 0. The assumption about the population for a chi-square test of independence is that the two variables are independent from each other. Since this chance is very low the assumption is probably not true, so I would conclude that there is a dependency between the two variables (one has an influence on the other).
Perhaps of interest my explanation on the term significance: peterstatistics.com/CrashCourse/1-Fundamentals/4-Significance.html
Hope this helps.
Please give the explanation such as if the significance value is less than alpha , Ho accepted /rejected
uhm, if significance value is less than alpha, then H0 is rejected, otherwise it is not rejected. Perhaps of interest: ruclips.net/video/Ttbid6GoFHc/видео.html