How To Calculate and Understand Analysis of Variance (ANOVA)

Assignment 3 – ANOVA
Overview
This competency introduces a number of tests which are used to compare groups. To determine which test to use, you must know the data distribution and type of data collected. All of the statistical tests can be performed using Excel. There are several resources accompanying this competency. Each concept is covered from a number of different perspectives to help you gain a thorough understanding.
One-way ANOVA Instructions
You’ve been asked to see whether there is a significant difference in rates of dehydration upon admission for patients 75 years and older (column HS) for Alabama, Georgia, and Louisiana. State your null and alternative hypotheses. Next, calculate the Sum of squares, squares within groups, squares between groups, and F statistic by hand. Now, use the ANOVA function within Excel for the calculation. What does the value of the F statistic tell you? Do you accept or reject the null hypothesis?
You will submit an Excel sheet and a Word document.
Resources
Introductory Statistics Part 13 Introduction
https://openstax.org/books/introductory-statistics/pages/13-introduction How To Calculate and Understand Analysis of Variance (ANOVA) F Test.
https://www.youtube.com/watch?v=-yQb_ZJnFXw&t=178s

How to Calculate ANOVA with Excel (Analysis of Variance)
https://www.youtube.com/watch?v=Ke9ttUj7AQc&t=466s

Excel – One-Way ANOVA Analysis Toolpack
https://www.youtube.com/watch?v=nmHFFFpOVZs&t=55s
GraphPad Statistics Guide
https://www.graphpad.com/guides/prism/7/statistics/f_ratio_and_anova_table_(one-way_anova).htm