Download files: https://people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch10/Ch10.htm
Topics in this video:
1. (00:12) Into to Hypothesis Testing for Population Differences Sigma NOT Known
2. (02:20) Excel Example for Hypothesis Testing for Population Differences Sigma NOT Known for formulas using functions such as: COUNT, AVERAGE, STDEV.S, SQRT, SUM, T.INV and T.DIST. Also see how to make the complicated Degrees Of Freedom Calculation less complicated using Smart Excel Setup.
3. (14:27) “t-Test: Two-Sample Assuming Unequal Variances” feature in the Data Analysis add-in, in the Analysis group in the Data Ribbon Tab.