Performing a chi squared test in Excel

An updated version of this video is available here:
mtweb.mtsu.edu/...
... along with a dataset that you can download and practice with. The video is part of the free "Excel Stats" online minicourse, which also covers one- and two-sample t-tests, a once-sample chi-square test, and bivariate regression. See:
mtweb.mtsu.edu/...

[@proudscorpio46]

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!

[@MsMindMeddler]

You just made my assignment so much easier...my teacher stinks and your awesome! Thank you!

[@tessaberg496]

I cannot express how happy i am to see this video. This is just perfect for what i am looking for. Thankyou!!

[@Weru212]

You have no idea how much you have helped me. Thanks a lot.

[@racquellintner]

Thank you! This helped me get my research paper done. Your explanation was quick and to the point.

[@mimokhan1]

Thank you, Finally, someone made it easier

[@crazyblah867]

You are a true legend. forever grateful

[@RizaPonciano]

This proved to be so useful. thanks. I almost gave up, and compute it manually (which would take ages). Thanks, really. :))

[@ylimeharas4166]

You have no idea how much you saved my butt just now, thanks!

[@MTBrenneman]

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

[@KenBlake]

Hmm ... I hadn't heard of this function, Matthew. Thanks. I'll check it out.

[@simfinso858]

How ? tell

[@merisho1]

the best method i saw so far, thanks for the author

[@jakewood6892]

This video was so straight forward and awesome! Thanks for posting this.

[@dka5631]

Thanks a lot! a very helpful tutorial without the length of a symphony

[@benjaminmoerenhout1157]

You re a hero! I wont fail my statistics exam

[@deeyears5269]

You're an absolute lifesaver! Thank you so much for this tutorial!

[@ArissaNeesan]

Thank you so much! I've been struggling for hours with theory on the internet couldn't understand anything lol

[@laceybathala1284]

Extremely simple explanation and use. Thank you!

[@emilieandersen-ranberg510]

Nice explanatory video. Helped a lot. Thank you for taking the time and effort...

[@XO-iz7js]

thank you, this helped a lot and was short and concise

[@boukailsameh3107]

Very simple and brief explanation, Thanks a lot!

[@suzylim6102]

THANK YOU SO MUCH! THIS HELPED ME A LOT WITH MY RESEARCH! GOD BLESS YOU! :)

[@mgibso29]

Thanks, this is really helpful.

[@Donyarit]

Really Good, this clip is very helpful for my research. Thank you very much.

[@vierwhey]

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

[@combatfrog69]

Thanks a lot. Greetings from Switzerland

[@MindStray]

Thank you! It helped me Significantly, lol. :)

[@monkeyape456]

NNNNNNEEEEEEEEEEEEEEEEEERRRRRRRDDDDDDDD ;)

[@MindStray]

Ughhhh war flashbacks to my master's thesis
Lmao

[@soccerup5899]

this is superb

[@saigayathri6436]

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

[@billieb0]

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?

[@KenBlake]

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

[@billieb0]

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

[@thetimeisninefifteen]

This was very helpful; many thanks, sir!

[@dr.pradyumnaraval4827]

Thank you very much. Easy and simplified.

[@tinaysfoodlab]

thank you so much for this. this video is much clearer! More power!

[@ButterflySimmer]

Thank you so much. i needed this for my assignment and get expected numbers. it all worked and saves me lots of time. :D

[@eatingtomorrow]

Thanks. Super clear and simple

[@mbenne30]

Very clear and helpful. Thanks!

[@thewtfpwnzor]

kind sir, you are my hero

[@kirilleremenko6952]

Thanks for this Chi-Squared test video!

[@jeffrey3690]

you saved my life

[@shadimlt]

Thank you so much. This video is so helpful....

[@anaghadagale2199]

This is very helpful thank you.

[@isobelzeitlyn4101]

thank you! this is such a great tutorial

[@josemunoz8264]

This is P value. Is there a test for the critical value?

[@keegandupons7498]

Thank you. Very helpful video.

[@taramishra9217]

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.

[@davidprince4535]

Is there a way to get Excel to give you the Chi Square test statistic or only the P valve?

[@mrwailee]

Thanks this was very helpful!

[@balkrishnaparab3353]

Aren't the frequency in cell required to be at least 5?

[@samanthafleury1210]

this was so helpful, thanks!

[@saigayathri6436]

awesome sir understood very well

[@teacookies37]

Great video! very helpful

[@abdallahabbasothman5231]

THANKS U VERY MUCH 😊😊

[@unplugged.rovers]

Extremely useful. thanx a ton..

[@sucharitasen7465]

Thank you so much. Awesome video

[@ayreonfreak]

Does it not work when any of your values is 0?

[@A-Listry]

how can i use chi-square to test more than two factors? like u have minority and white. Can I have three factors?

[@Lamyaamajeed]

Thank you!

[@qabilhuseynov7098]

Thank you very much!! Very helpfull.

[@bleahblabella]

thank you! so helpful!

[@fnunnari]

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

[@shawols91]

Thank you so much!!!! :D

[@Miossoty1]

should chitest on excel be done only on absolute values or can it be done on percentages?

[@SeungjinLee]

thanks a lot! that was helpful!

[@cheesy1760]

Thank you so much!

[@shanthygeorge4244]

Thank you

[@monkeyape456]

hi is it possible to use this for percentages?

[@gnlilu6972]

OMG! THANK YOU SO MUCH!

[@bradu3]

Very helpful..

[@TucsonPalm]

Thanks ken

[@kvr0se575]

Thanks!

[@MellvinGeorgePerscy]

thanks a ton!

[@handsomeman5170]

Appreciate !!!!
very useful

[@jayjennings5]

thank you...

[@shridharhodlur170]

Thank u very much

[@ScarrVett]

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

[@bulletkip]

thanks!

[@thabsmk7840]

Thanks a lot :D

[@joeberenguer3267]

Awesome

[@ShyShyRich]

THANK YOU! STATISTIC PROFS SUCK!!

[@pastelitohouston]

thanks bud gracias

[@sirX0001]

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

[@luvbotlunari]

WALA AKONG MAINTINDIHAN HUHU