I actually had your class for journalism and remember you were the only teacher that ever made me understand excel well. Now I’m in statistics and stumble upon your video on RUclips… how cool! Your super helpful so I’m sure it helps many people out!
You can use MMULT to compute the entire contingency table of the expected counts just using one command (as opposed to doing computations for every cell).
Null hypothesis: There is no relationship between the race with the cases. Alternative hypothesis: There is a pattern between the cases. Since the p-value is less than 0.05, the null hypothesis is rejected. That means there is a pattern in the data.
Bruce Sellmeijer Bruce: Yes. See this video: mtweb.mtsu.edu/kblake/excelstats_1samplechisq.html. To illustrate an application of the technique to the scenario you describe, let's imagine that, across 50 random trials, Species X chooses Chamber A 33 times and Chamber B 17 times. Obviously, Species X chose Chamber A more often. But can pure randomness account for the pattern? To find out, open Excel and type "Observed," "33" and "17" in cells A1, A2 and A3, respectively. Then type "Expected," "25" and "25" in cells B1, B2 and B3, respectively. The "25" and "25" in B2 and B3 represent what Species X would do in a purely random situation. Out of 50 trials, it would choose Chamber A exactly half the time (25) and Chamber B the other half of the time (25). With the data thus arrayed, this formula: =CHITEST(A2:A3,B2:B3) ... will compare the observed counts in Column A with the expected counts in Column B and return a chi square probability of 0.023652, or about 2 percent. That's less than 5 percent, suggesting that Species X's preference for Chamber A is the result of some nonrandom process. Hope that helps. Ken
its very useful . But I have a doubt in expected column . how will you able to expect that value for whole dataset . assumption that it contains 10000values
I doesnt work on later excel dokuments... all i get is "Are you sure you want to use = it is a equation formel you are typing. Type ( , ) to remove. I try to ignore it and highlight the secound boxes. There isnt a chitest option, there is chi 2 test and when i try to enter it, it just go NAME in the box and disappear when i try type in the box..
Sorry, but I have some doubts about the conclusions. From the video I understand that the smaller is the value, the more is the probability that the measured values are NOT random and follow a pattern. However, to me it looks like the p-value works the opposite. The returned p-value is the "probability that the null hypothesis is satisfied", i.e., that the measured values are the same as the expected ones. So I would expect that, if the measured values follow a pattern, the resulting p is close to 1.0, not to zero. Indeed, if you use the same values for both measured and expected data, the resulting p is exactly 1.0. Can you check it? I'm new to chi-square and I might have misunderstood. Best regards
I'm working on Chi Squared in Google spreadsheets, while I decided to procrastinate on RUclips-- ...And somehow this appeared in my recommended. ..I haven't looked up anything like this on RUclips, so wow this is creepy
The interpretation of the p-value in this video is not correct. If the p-value is less than 0.05, then that means we reject the null hypothesis. For a better understanding of doing a chi squared test with two-way tables, see this example: www.stat.yale.edu/Courses/1997-98/101/chisq.htm
I actually had your class for journalism and remember you were the only teacher that ever made me understand excel well. Now I’m in statistics and stumble upon your video on RUclips… how cool! Your super helpful so I’m sure it helps many people out!
You just made my assignment so much easier...my teacher stinks and your awesome! Thank you!
I cannot express how happy i am to see this video. This is just perfect for what i am looking for. Thankyou!!
You have no idea how much you have helped me. Thanks a lot.
Thank you, Finally, someone made it easier
You are a true legend. forever grateful
You can use MMULT to compute the entire contingency table of the expected counts just using one command (as opposed to doing computations for every cell).
Hmm ... I hadn't heard of this function, Matthew. Thanks. I'll check it out.
How ? tell
You have no idea how much you saved my butt just now, thanks!
This proved to be so useful. thanks. I almost gave up, and compute it manually (which would take ages). Thanks, really. :))
Thank you! This helped me get my research paper done. Your explanation was quick and to the point.
thank you, this helped a lot and was short and concise
You re a hero! I wont fail my statistics exam
This video was so straight forward and awesome! Thanks for posting this.
Nice explanatory video. Helped a lot. Thank you for taking the time and effort...
the best method i saw so far, thanks for the author
Null hypothesis: There is no relationship between the race with the cases. Alternative hypothesis: There is a pattern between the cases. Since the p-value is less than 0.05, the null hypothesis is rejected. That means there is a pattern in the data.
You're an absolute lifesaver! Thank you so much for this tutorial!
Thank you so much! I've been struggling for hours with theory on the internet couldn't understand anything lol
Thanks a lot! a very helpful tutorial without the length of a symphony
Very simple and brief explanation, Thanks a lot!
Extremely simple explanation and use. Thank you!
THANK YOU SO MUCH! THIS HELPED ME A LOT WITH MY RESEARCH! GOD BLESS YOU! :)
Really Good, this clip is very helpful for my research. Thank you very much.
thank you so much for this. this video is much clearer! More power!
Thanks, this is really helpful.
Thank you so much. i needed this for my assignment and get expected numbers. it all worked and saves me lots of time. :D
Thank you very much. Easy and simplified.
This was very helpful; many thanks, sir!
Is there a way to get Excel to give you the Chi Square test statistic or only the P valve?
Thanks for this Chi-Squared test video!
Is this also possible to do when you only have one independent variable? So like a choice experiment where species X has to choose between 2 chambers?
Bruce Sellmeijer Bruce: Yes. See this video: mtweb.mtsu.edu/kblake/excelstats_1samplechisq.html. To illustrate an application of the technique to the scenario you describe, let's imagine that, across 50 random trials, Species X chooses Chamber A 33 times and Chamber B 17 times. Obviously, Species X chose Chamber A more often. But can pure randomness account for the pattern? To find out, open Excel and type "Observed," "33" and "17" in cells A1, A2 and A3, respectively. Then type "Expected," "25" and "25" in cells B1, B2 and B3, respectively. The "25" and "25" in B2 and B3 represent what Species X would do in a purely random situation. Out of 50 trials, it would choose Chamber A exactly half the time (25) and Chamber B the other half of the time (25). With the data thus arrayed, this formula:
=CHITEST(A2:A3,B2:B3)
... will compare the observed counts in Column A with the expected counts in Column B and return a chi square probability of 0.023652, or about 2 percent. That's less than 5 percent, suggesting that Species X's preference for Chamber A is the result of some nonrandom process.
Hope that helps.
Ken
Ken Blake Hi Ken, thanks A LOT for your fast response, you've been very helpful. Awesome that you took your time to come with an example.
Bruce
Thanks a lot. Greetings from Switzerland
Thank you so much. This video is so helpful....
you saved my life
Thanks. Super clear and simple
Thank you! It helped me Significantly, lol. :)
NNNNNNEEEEEEEEEEEEEEEEEERRRRRRRDDDDDDDD ;)
Ughhhh war flashbacks to my master's thesis
Lmao
Thank you. Very helpful video.
its very useful . But I have a doubt in expected column . how will you able to expect that value for whole dataset . assumption that it contains 10000values
Very clear and helpful. Thanks!
thank you! this is such a great tutorial
awesome sir understood very well
should chitest on excel be done only on absolute values or can it be done on percentages?
kind sir, you are my hero
Great video! very helpful
hi is it possible to use this for percentages?
Thanks this was very helpful!
Thank you so much. Awesome video
Extremely useful. thanx a ton..
this is superb
this was so helpful, thanks!
I doesnt work on later excel dokuments... all i get is "Are you sure you want to use = it is a equation formel you are typing. Type ( , ) to remove. I try to ignore it and highlight the secound boxes. There isnt a chitest option, there is chi 2 test and when i try to enter it, it just go NAME in the box and disappear when i try type in the box..
Aren't the frequency in cell required to be at least 5?
how can i use chi-square to test more than two factors? like u have minority and white. Can I have three factors?
THANKS U VERY MUCH 😊😊
Does it not work when any of your values is 0?
This is P value. Is there a test for the critical value?
Thank you!
Thank you very much!! Very helpfull.
thank you! so helpful!
thanks a lot! that was helpful!
Thank you so much!
Thank you
Thank you so much!!!! :D
Thanks ken
Sorry, but I have some doubts about the conclusions.
From the video I understand that the smaller is the value, the more is the probability that the measured values are NOT random and follow a pattern.
However, to me it looks like the p-value works the opposite.
The returned p-value is the "probability that the null hypothesis is satisfied", i.e., that the measured values are the same as the expected ones. So I would expect that, if the measured values follow a pattern, the resulting p is close to 1.0, not to zero. Indeed, if you use the same values for both measured and expected data, the resulting p is exactly 1.0.
Can you check it? I'm new to chi-square and I might have misunderstood.
Best regards
OMG! THANK YOU SO MUCH!
Thanks!
Very helpful..
thank you...
thanks a ton!
Thank u very much
Appreciate !!!!
very useful
thanks!
I'm working on Chi Squared in Google spreadsheets, while I decided to procrastinate on RUclips--
...And somehow this appeared in my recommended.
..I haven't looked up anything like this on RUclips, so wow this is creepy
Awesome
THANK YOU! STATISTIC PROFS SUCK!!
Thanks a lot :D
thanks bud gracias
The interpretation of the p-value in this video is not correct. If the p-value is less than 0.05, then that means we reject the null hypothesis. For a better understanding of doing a chi squared test with two-way tables, see this example: www.stat.yale.edu/Courses/1997-98/101/chisq.htm
WALA AKONG MAINTINDIHAN HUHU
This is very helpful thank you.