Perform Chi-Square Test Of Independence In Excel (Including P Value!)
Steven Bradburn Steven Bradburn
88.6K subscribers
301,022 views
0

 Published On Jul 5, 2021

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

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/198849...
YouTube SEO https://www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)

FOLLOW US
Website https://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.

show more

Share/Embed