Raw data is often voluminous, and spreadsheets we create can often be quite large. It is helpful to have data you are analyzing in a single worksheet, so you can manipulate it for additional analysis at a later date. Note that Excel will allow you to create multiple worksheets in a single document.
For this assignment, you will continue building upon your previously submitted Excel worksheet.
ASSIGNMENT INSTRUCTIONS
Again using the Dayton & Montgomery County Public Health website, pull the data from the first graph on the accidental overdose death totals for 2018 and 2019.
- Label your column C “2018” and enter the data in that column.
- Label your column D “2019” and enter the data in that column.
- When you are done labeling your worksheet and entering the data for 2018 and 2019, calculate your descriptive statistics for both data sets.
- Label your output tables so your instructor can clearly identify the descriptive statistics for each of the years indicated.
- In a separate Word document (1-2 pages), imagine you are describing your data to a layperson. What does each of the descriptives tell you about each data set? Be sure to describe what each measure of central tendency and variability from your Excel output table tells the reader about what the data actually says. Identify the differences in each of the three data sets’ descriptives (2017, 2018, 2019).
Be sure and save your worksheet as we will revisit it later.
Submit your completed Excel worksheet and Word document.
0 comments