Download files: https://people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch10/Ch10.htm
Topics in this video:
1. (00:12) Introduction to Completely Randomized Design and Analysis of Variance (ANOVA) for Comparing More Than 2 Population Means
2. (13:02) Formula method – Long Method, including F.INV.RT function for F Critical Value and F.DIST.RT for p-value
3. (29:57) Formula method – Short Method using Array Formulas and SUMPRODUCT function, including F.INV.RT function for F Critical Value and F.DIST.RT for p-value
4. (41:43) “Anova – Single Factor” feature in the Data Analysis add-in