In this video, we discuss the basic process for computing a chi-square test for independence step-by-step in Excel using college enrollment data.
The heart of this video is the computation of chi-square to determine with 95% confidence whether or not the variation in the enrollment could be explained by random chance alone. We discuss how to find the critical chi-square value in Excel and locate both the problem and critical chi-square values on the chi-square distribution.
My playlist table of contents, Video Companion Guide PDF documents, and file downloads can be found on my website: https://www.bcfoltz.com