What does the value of the F statistic tell you? Do you accept or reject the null hypothesis? Next, calculate the Sum of squares, squares within groups, squares between groups, and F statistic by hand.

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.