EXAMINE THE BURDEN OF DISEASE IN THE UNITED STATES TO PROVIDE IMPORTANT INFORMATION ON WHICH PARAMETER IS TO BASE DECISIONS ON PUBLIC HEALTH PRIORITIES.

Examine the burden of disease in the United States to provide important information on which parameter is to base decisions on public health priorities.

To do this, we will utilize mortality data for the United States. In the first part of this assignment, you will download and examine mortality data for your home state.

Go to USA Causes of Death by Age and Gender

• Choose your home state under the Choose State option (panel on left hand side)
• Select BOTH under the Choose gender option in the middle panel.
• Scroll down to the bottom of the page, and read the fine print to learn for which year the mortality data have been tabulated.
• Copy and paste the relevant mortality data into Excel.
  • Drag your mouse over all of the Cause of Death rows, (50 rows), right click, and select Copy,
  • Open Excel and paste your selection into Excel. You should have a spreadsheet with 50 row and 19 columns (Columns A-S).

For the first part of the assignment, you will prepare a histogram of the leading causes of death (regardless of age) in your state. Follow the steps below in order to prepare your histogram:

• Sort the Data
  • The numbers of deaths, all ages, are given in Column C.
  • Select all the columns.
  • Then, select Data>Sort>Sort by Column C, Values, largest to smallest. (Make sure that my data has headers is not selected.
  • You now have the leading causes of death in your state in Column A (cause) and Column C (frequency).
• If you already know how to draw a histogram in Excel, proceed to do so with Columns A and C, making sure to truncate the data to the 30 leading causes.
• If you do not know how to draw a histogram in Excel, here’s one method:
  • Choose the Chart Wizard, chart type column, chart sub-type clustered column (Step 1).
  • Click Next for St