Perform Chi-Square Test Of Independence In Excel (Including P Value!)

In this tutorial, I will show you how to perform a chi-square test of independence by using Microsoft Excel. This includes step-by-step instructions, to generate a p-value.
ONLINE GUIDE
toptipbio.com/chi-square-test...
VIDEO CHAPTERS
00:00 Intro
00:18 My example data
00:58 Calculate row and column totals
02:50 Calculate expected values
04:11 Calculate difference between observed and expected
05:12 Calculate the chi-square value
05:39 Calculate the degrees of freedom
06:06 Calculate the p-value
07:37 Using the CHISQ.TEST function
08:10 Wrapping up
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
CZcams SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

[@StevenBradburn]

ONLINE GUIDE
toptipbio.com/chi-square-test-independence-excel/

[@karimesolis2952]

You became my favorite person in the world. I was really stressed out because a couldn’t calculate the chisq to a result of an investigation, but you explained super clear and finally i can finish my project. Thank you so much!!!

[@teresabaiao4385]

A video from 2 years ago SAVED MY LIFE!!!
Thank you for such a great explanation!!!

[@bigpeenerpeen]

you just got cited in my lab report since I used your methods in my methodology and results section for my results, thank you.

[@Pathodoc96]

You are so amazing! The explanation was crystal clear! You’ve literally saved me!! Thank you so much!

[@nickchalmers3558]

Thank you for this. As someone who hasn’t done stats for 20years this was by far the easiest to follow explanation I have found.

[@sthashib1858]

Easiest video on chi square. great job.

[@koda_pop7849]

I want you to know that this video literally saved my day. I have to take a poster to a conference and I kept getting recommended using one-way ANOVA, which gave me very silly results for my binomial data set. Thank you very much friend

[@rbarkley949]

Thank you! This is so much easier and so much clearer than any of the others!

[@christirichardson1830]

Oh my, this helped me SOOOOO much!!! Thank you!!

[@jakubstefan5700]

I have an exam from statistics. You are my savior! Thank you.

[@TheMuralidharprasad]

Thank you. Very Good, Simple and Easy to understand

[@mithu8862]

Your video SAVED MY LIFE!!! Thank you so much for such a wonderful & easy explanation

[@doraionik5329]

Thank you so much, i was so stressed and did not find anything helpful until i came across your video. You saved me and my thesis, I can not thank you enough😓❤❤

[@marleydundas484]

thank you i love you you’re a gift of god thank you

[@PiduguVijay]

thanks for the video, it's very clearly explained.

[@travel-pro618]

You are truly amazing ... I was tensed due to details mentioned in literature and now uou made it soo simple and easy to implement... wow love your work

[@ginanaiding6264]

Thank you so much for this. It was very helpful for me as a beginner. Your flow of teaching was also right for me. 👍

[@albelikiran]

Thank you so much for this video! So helpful!

[@user-qf7hh6jg2w]

Super helpful for my Botany students when analyzing their experiment data. Thanks!!

[@brandonopara7778]

Thank you so much!!!!!!!!!!! Made it so simple!

[@gnanithasuryadevara4480]

Thank you so much, you saved my day

[@user-wf7ju3xq6o]

Thank you so much for this, it was extremely helpful!

[@carlalcabrera]

Thank you 🙏🏻 for making this video

[@litzymejia2041]

This was superrrr useful thank you so much.

[@robertojukwu]

Great tutorial!!!

[@Nerd_rad2370]

Thank you so much for this! This was great

[@maxmorris4562]

Thanks, I liked your tutorial

[@OriginalDingus]

Very much appreciated. This helped me cut down 3 hours of hand work down to 30 minutes of excel. You are a life saver. Now if i can just get my group to contribute with our work it will be even less time consuming LOL.

[@midazolam1234567]

Excellent. Thank you so much.

[@Nusratparvin29]

thanks a lot. my work got a lot easier after watching this. 😁😁

[@deculawanangelfaithn.9066]

Thank you so much sir!❤️❤️❤️

[@tumblebee07]

Thank you so much for this video. I suck at statistics and Ive got a paper due tomorrow and this has helped me solve a data set in under 2 hours compared to the over 6 hours it took to solve a different data set yesterday :)

[@casimirangeline6770]

Very helpful, thanks

[@skyequan9889]

THANK YOU so much!!!!!

[@reddofly]

Thank you so much! So helpful and easier to understand than Coolican. :D

[@maryalexisnnaji2289]

Thank you for this. You just saved my life literally😂

[@praneethd9436]

WELL EXPLAINED

[@mohammed10338]

You are a legend sir
Thank you

[@himsdohtrccdo8124]

Thank you so much

[@hongquannguyen3987]

thank you, you save my test

[@spencerflanders8906]

Thank you so much you saved me for my test

[@karag4487]

Great content

[@dhakprasadupreti6249]

Good job for students, thanks very much

[@thatzevy]

THANK YOU SO MUCH! This taught me more than my class lectures lol

[@StevenBradburn]

You're very welcome!

[@prosario0308]

So simple and easy to follow, thank you!

[@islamabdillahi7437]

thank youuuuuuuuuuuuuuuuuuuu for this

[@LovePrabanjam]

Excellent 👍👍👍

[@LetsLearnwithAnjuma]

Super tutorial Sir

[@jacobfitzgerald3278]

bless you king

[@anapaulacortes9561]

THANK YOU VERY MUUUCCCHHHHHHHH

[@reamabdulsalam524]

Really the best channel in the world many thanks for this brief explanation I am really very satisfied , can you please go with us step by step from downloading R and R studio and show us how to use R we are struggling and the information online is not enough to work on this programme thanks

[@tejjm4263]

Legend!

[@changzhiji]

Nice

[@kuldeepyadav2238]

Nice ❤️ ❤️ ❤️

[@syafiqsams6029]

thanks sir

[@sms6680]

fine

[@farmersfriend4492]

Thank you, How can we test it for a single variable?

[@drehab2000]

Thank you so much. Can we apply it if the total sample number is 25? Thank you, I really appreciate it.

[@user-zg8iu9gp6e]

Hi Steve
Thanks so much for your video - really useful. However, how do I do the Chi square test for proportions with more than one categorical group. For example, I ask 3 cohorts (healthy, anxious and depressed) if they smoke (yes/no)? Thanks in advance

[@harryparkes5076]

can you do one of these with one row and two columns

[@barryfeng6602]

how to do it in r without built-in func?

[@erhunohanmu8940]

Can I use chi square if I have 4 independent variables to be tested against a Yes or No response? If not, what’s suitable for such analysis?
Thanks in advance 🙏

[@michaelefrem7825]

Its very helpful. Thanks. What means if P-value is zero?

[@seco9349]

It van never be zero, as there is always the smallest probability that it might actually happen

[@kinga1996]

Can I use this method with multiple choice questions?

[@jyotiradityavirdi5075]

i have a 2-way table with some zeroes in the data set, i cannot find the chi square test in many calculators , can you help? @top tip bio

[@roseytb4092]

is there a calculator which has the chi-square function but which is non-programmable? because in the exam I am not allowed to have a programmable calculator.

[@aamirghanchi9487]

Can the interdependence of the categories be established simply by using the Observed values and not using Expected values?

[@carsongxd]

Clutch

[@miat1327]

Hi, I was curious why you did not have to use the Chi-Square possibilities table in order to determine if you reject the null hypothesis? Why did you default to alpha 0.05?

[@lmoore9524]

.05 is the most common convention and means there is only 1 chance in 20 this result happened by chance. You could choose .01 for a more strict test of 1 in a 100 chance or .10 for 10 out of 100 to be less strict in ruling out the null assumption.

[@rmtascpi5936]

is it also applicable when you have, instead of female and male, you have three ages (examples are 18-19,20-21,22-23)?

[@mahinhasan7706]

why am i getting 2 different p-values when I use CHISQ.DIST.RT vs CHISQ.TEST

[@ogechichilaka6294]

I noticed same. I think CHISQ.TEST works for only 2×2 table

[@amarpratap8785]

​@@ogechichilaka6294I got different results for even 2×2 table

[@sukeshinikhandagale7271]

is it association of gender to smoking or the unequal distribution of gender between the groups? Can we say that both groups have unequal sample distribution for each sex? What i mean is can i have test for gender distribution between both groups?

[@killuaxd1387]

how do i find my alpha level??

[@paramasakthi2798]

Sir, I have a doubt. you have done for 2*2variables..Can we do it for 3*3 variables..Is it correct to do chisquare test for 3*3 variables

[@domihoaimeyedenou3104]

It displaying a syntax error message

[@ridha3248]

The values of p are like 0.7,0.8 , 0.8 , 0.4 etc
Is this a problem . Because i knoe is should be less than 0.05

[@aamirghanchi9487]

If we can accept or reject the null hypothesis based on the chi-square value alone, then why is there a need to derive the P value from it. Why an extra step?

[@naveenshaji9020]

Actually you can only reject or fail to reject null hypothesis.

[@aamirghanchi9487]

According to you, the Null hypothesis will be accepted if P > 0.05 and rejected when P < 0.05. This is opposite to what this gentleman is stating. Which one is correct? czcams.com/video/WXPBoFDqNVk/video.html

[@CheyenneBurkett]

Who else is here from Rosemary Wilsons bum ass class ?

[@nourhfaith9510]

Thank you so much