State your null and alternative hypotheses. 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.

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