✉️ Join my newsletter
https://steven-bradburn.beehiiv.com/subscribe
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
https://toptipbio.com/chi-square-test-independence-excel/
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 https://techsmith.z6rjha.net/c/1988496/506622/5161
YouTube SEO https://www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website https://toptipbio.com/
Facebook https://www.facebook.com/TopTipBio/
Twitter https://twitter.com/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.