How to perform a chi square test for one variable in Excel

This video shows How to perform a chi square test for one variable using Excel. Tests equality (=) of proportions. In general, the chi-square (χ2) test is a useful statistical test to look at differences with categorical variables.
Compares observed count to expected count assuming null hypothesis is true
Closer observed count is to expected count, the more likely the H0 is true"
For this one-way classification, the x2 distribution has (k - 1) degrees of freedom
A multinomial experiment has been conducted. This is generally satisfied by taking a random sample from the population of interest.
The sample size n is large. This is satisfied if for every cell, the expected cell count Ei will be equal to 5 or more.
#excel #inferentialstatistics #exceltutorial