EXCEL AND COMMUNICATING PUBLIC HEALTH DATA

Excel Activity

1. Create a new Excel spreadsheet. Title it Excel 1_YourLastName
2. Merge & center cells A1 & B1.

   

3. Type Death Rates (any state of your choosing in parenthesis)
4. On column A cell 2, start typing the five top causes of deaths from the top down (select one state of your choosing besides Alabama): Heart disease, Cancer, Pulmonary disease, Accidents, and Alzheimers.
   

   	A	B
   1	Number of deaths (Alabama)
   2	Heart disease	2712630
   3	Cancer	595930
   4	Respiratory disease	155041
   5	Accidents	146571
   6	Alzheimers	110561

5. Using Alabama as an example you would record the following data for column B:
• Heart disease: 2712630
• Cancer (neoplasms): 595930
• Respiratory diseases (chronic lower): 155041
• Accidents (unintentional): 146,571
• Alzheimers: 110561
6. Select cells A1 & B1 and paint it a color of your choosing.
7. Highlight cells A2-6 and cells B2-6, click on the insert tab, and select pie (2D pie)
8. Click on your chart and select chart title then chart element. From the drop down, select above chart. Type in Number of Deaths (state) as the pie chart title.
9. Select a different state and create a column graph. After you have entered your data for your second state, highlight the two columns with types of deaths (same top 5 as first graph) and number of deaths. Insert a column graph.
10. After you have entered your graph, add a title above the graph the same way you did with the first state.

Submit a Word document with both graphs. Summarize the results of each graph and address the following questions:

• What did you find out from your work? (make data comparisons between states and at the national level).
• What is the best way to summarize your data and then display it? Why?