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:12) Intro to Chi-Square Hypothesis Test Independence Between 2 Categorical Variables with 2 PivotTables and one set of formulas.
2. (01:19) How to take survey results for 2 categorical variables and test whether the “Hiring Over The Next Year” variable is independent of “Firm Type” (Private or Public) variable using Chi Square.
3. (03:35) How to place the correct “Response Variable” into the row area of the cross tabulated table and how to place the correct “Explanatory Variable” into the column area of the cross tabulated table.
4. (04:23) How to think of a Test of Independence in terms of adding a second variable to the “Response Variable” to break apart “Response Variable” Proportions into Two Separate proportions based on a second variable.
5. (07:34) Formulas for Test of Independence
6. (08:42) 6 Steps in to Chi-Square Hypothesis Test Independence Between 2 Categorical Variables.
7. (10:06) How To Run Test of Independence with PivotTables and Formulas from a Proper Data Set.
8. (10:46) PivotTable for Observed Frequencies
9. (11:57) PivotTable for Sample Proportions
10. (12:46) Copy and Paste Values and Format from PivotTable to make Formula Table
11. (13:43) Formulas for Expected Frequencies in a Cross Tabulates (or Contingency Table) using Mixed and Absolute Cell References.
12. (16:40) Array Formula in AND function to check if all Expected Frequencies are Greater than or Equal to Five.
13. (19:13) Get rid of GetPivotData Function
14. (20:00) CHISQ.TEST function to calculated p-value from Observed Frequencies and Expected Frequencies.
15. (20:58) Step 5: Conclusion
16. (21:26) Step 6: If we reject the Null Hypothesis Test, calculate Sample Proportions and Charts