Stats Apps Tutorials: 16. One-way ANOVA in Excel (by hand)
Links to video sections and data files are in the description below. In this tutorial video we go through the steps to perform a one-way univariate analysis of variance (ANOVA) using Excel.
*note for the final part of this tutorial you need to have the Data Analysis Toolpak enabled. See my earlier video: • Stats Apps Tutorials: 5. Descriptive stati...
Data files used in this video:
ANOVA_NHL_salaries.xlsx:
https://www.mediafire.com/file/2q9y2y...
Sections:
00:00 Introduction
00:24 Calculating ANOVA by hand in Excel
09:20 Determining if the F-ratio is significant
10:34 Calculating eta-squared effect size
11:20 Calculating ANOVA using data analysis functions
Subscribe here: Subscribe here: / @tonycarlsen1627