Many statistical procedures call for complex and lengthy mathematical formulas. Thankfully, there are a wealth of software programs that can calculate these statistics for us. You may have heard of some of these programs, and many have incredible functionality for those who work with statistics on a regular basis.

For the vast majority of us who are not statisticians, Excel is a commonly used program and has an excellent variety of statistical tools available. In order to utilize and access these tools easily, your first step will be to add on the data analysis toolpack to your Excel account.

Let's run some descriptive statistics using Excel. The short video at the beginning of the assignment walks you through the data analysis toolpack add-in and the process for running descriptive statistics.

Questions

Using thehttps://www.mccoat.org/data-reportspull the data from the first graph on the website, which shows the accidental overdose death totals for the county. Limit your data to 2017, 2018 and 2019, and enter that data into an Excel worksheet.

• Label your worksheet "Accidental Overdose Death Totals Montgomery County,"
• Label your column A "Month."
• Label column B "2017", column C "2018", and column D "2019" and enter the respective numbers of overdose deaths per month.
• When you are done labeling your worksheet and entering the data, calculate your descriptive statistics for the three data sets. *Note, you will follow the instructions in the above video and produce three output tables.
• Imagine you are describing your data to a layperson. What does each of the descriptives tell you about the data set? Be sure to describe whateachvariable on your Excel output table tells the reader about what the data actually says foreachdata set. Compose this document as if an individual is approaching you, asking for information about the overdose deaths in Dayton for these three years, and cannot actually see the data. Identify the differences in each of the three data sets' descriptives (2017, 2018, 2019).