Sunday, July 11, 2021

Calculate a Chi Square Test with Excel

A Chi (rhymes with the word "my" but starting out with a "k" like kite) squared test is used to determine the relationship between observed and expected values that are categorical variables. This means items that are counted, so this type of test would be used for continuous variables like weight or height. Excel has some useful functions that will perform Chi squared calculations BUT you'll still need to calculate out the Chi squared test statistic based on your data. Check out the video for two examples of Chi squared - goodness of fit and test for independence.

No comments:

Post a Comment