Please see attachment for assignment

creating graphs by making a chart or table using data from the CDC on leading causes of death by state.

The following resource provides data for this assignment: National Center for Health Statistics. Mortality Data. Centers for Disease Control. Retrieved from https://www.cdc.gov/nchs/data/dvs/LCWK9_2015.pdf

Excel Activity

Create a new Excel spreadsheet. Title it “Excel 1_YourLastName”
Merge & center cells A1 & B1.  
Type “Death Rates (any state of your choosing in parenthesis)”

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 Alzheimer’s. 


	Number of deaths (Alabama)
	Heart disease	2712630
	Cancer	595930
	Respiratory disease	155041
	Accidents	146571
	Alzheimer’s	110561

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
- Alzheimer’s: 110561
Select cells A1 & B1 and paint it a color of your choosing.
Highlight cells A2-6 and cells B2-6, click on the insert tab, and select pie (2D pie)
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.
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.
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?

SLP Assignment Expectations

For this SLP assignment you will submit two separate documents: your Excel spreadsheet with both data and graphs, and a properly formatted Word document approximately 1-2 pages in length summarizing your results (the total length does not include title page or reference page).