ANOVA in Excel using the data from the Dayton Public Health

Let’s revisit our data worksheet from Module two, where you ran t-tests on the data from the Dayton & Montgomery County Public Health website. https://www.mccoat.org/data-reports

In assignment 1.5, you were asked to compare means between the 2017 and 2018 data, and the 2018 and 2019 data. Although t-tests are very useful when we are comparing two samples, ANOVAs are better utilized when we have more than two samples. The video above can assist you in conducting an ANOVA for this data in Excel. For additional information about ANOVA, please see the video below.

ANOVA Explained https://youtu.be/uzcqMeNK7Kw?si=kVz-qSBX7aI2Ek4e

ASSIGNMENT INSTRUCTIONS

Conduct an ANOVA in Excel using the data from the Dayton Public Health Website you previously gathered. You will only need to run the one-way ANOVA for this assignment.
Be sure to label your output as ANOVA and submit your worksheet.
In a separate Word document, describe what an ANOVA does, why it is useful, and what your results showed to an individual with no access to the data or knowledge of statistics. (*Note: In some cases, when the p-value is very significant, you will see an E- and a number after your p-value on your output table. This means you need to move the decimal place to the left the number of spaces indicated by the number following the p-value to determine the exact value.)
Copy textView less