Let’s revisit our data worksheet from Module two, where you ran a t-test on the data from the Dayton & Montgomery County Public Health website.
In assignment 2.3, 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.
Conduct an ANOVA in Excel using the data from the Dayton Public Health Website you previously gathered.
Be sure to label your output as ANOVA and submit your worksheet.
In a separate Word document, describe what your results say in a way that is easily digestible to an adult.
Submit your completed Excel worksheet and Word document. To submit your second document, click “Add Another File” under your first file upload: