Combo order 1 page Coursework for Excel This assignment is due Week 1: Sunday by 11:59 pm ET. 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. If you are completely unfamiliar with Excel, the link to the Excel help website is listed in your Lifeline, and will provide you with the basics of navigating the software. Your module notes have introduced you to descriptive statistics. The videos below also provide additional information on skew and kurtosis: https://www.youtube.com/watch?v=XSSRrVMOqlQ (Links to an external site.) https://www.youtube.com/watch?v=t0vkRd_FNi0 (Links to an external site.) 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. ASSIGNMENT INSTRUCTIONS Using the Dayton & Montgomery County Public Health website (Links to an external site.), pull 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. 1. Label your worksheet “Accidental Overdose Death Totals Montgomery County,” 2. Label your column A “Month.” 3. Label column B “2017”, column C “2018”, and column D “2019” and enter the respective numbers of overdose deaths per month. 4. 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. a separate Word document (2-3 pages), 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 what each variable on your Excel output table tells the reader about what the data actually says for each data 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). 6. Be sure and save your worksheet as we will revisit it later.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|