Download files (which file shown at begin of video): https://people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch11/Ch11.htm
Topics in this video:
1. (00:14) Introduction to “Hypothesis Test to check Equality of 2 or more Population Proportions using Chi-Square” with Example of check the error rates between 4 populations.
2. (03:08) Introduction to Chi-Square Distribution
3. (06:09) Continue example of using Chi-Square Hypothesis Test to check the error rates between 4 populations, where each population is a different year and each proportion represents error rate for data entry.
4. (08:57) 5 Steps for Chi-Square Hypothesis Test to check Equality of four Population Proportions, including examples of all formulas and Excel functions in the hand drawn pdf file.
5. (15:50) Excel Example of Chi-Square Hypothesis Test to check the error rates between 4 populations, where each population is a different year and each proportion represents error rate for data entry. Examples of all formulas and Built-in Functions
6. (16:25) Formula for Cross Tabulated “Observed Frequencies” Table using COUNTIFS function, Column References and Mixed Cell References with the Column Locked (Absolute).
7. (19:25) Calculate Sample Proportions (Pbar1, Pbar2, Pbar3, Pbar4) in a cross tabulated table using Mixed Cell References with the Row Locked (Absolute).
8. (20:45) Formula for Cross Tabulated “Expected Frequencies” using Relative, Absolute, and Mixed Cell references.
9. (23:18) Long Method with Step by Step Cross Tabulated Tables for calculating Chi-Square Test Statistic.
10. (25:21) Short method to calculated Final Chi-Square Test Statistic using array calculations and the SUMPRODUCT function.
11. (26:38) Calculate p-value using CHISQ.INV.RT Function
12. (27:45) Calculate Critical Value (Hurdle) using CHISQ.INV.RT
13. (28:17) Calculate p-value from Observed Frequency Table and Expected Frequency Table using CHISQ.TEST function