Instruction
Let's revisit our data worksheet from the previous Module, where you ran a t-test on the data from the Dayton & Montgomery County Public Health website. https://www.mccoat.org/data-reports
In that assignment, 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. https://www.youtube.com/watch?time_continue=4&v=q4vd0RYkd0g&feature=emb_logo
https://www.youtube.com/watch?v=nmHFFFpOVZs
ASSIGNMENT INSTRUCTIONS
• Conduct an ANOVA in Excel using the data from the Dayton Public Health Website you previously gathered. (See the excel spreadsheet)
• Be sure to label your output as ANOVA and submit your worksheet.
• In a separate Word document and not less than 400 words, describe what your results say in a way that is easily digestible to an adult.