Develop 2-line graph using Microsoft Word or Excel for the top 2 most common cau
ID: 3054838 • Letter: D
Question
Develop 2-line graph using Microsoft Word or Excel for the top 2 most common causes of death from an age category of your interest and report the "age and adjusted rate" trend of death occurrences for the period of 2005 through 2009
*Note- Table is complete make sure to scroll all the way to the right to see the entire data*
TABLE 1. Leading causes of death — United States, 2005–2011*
Cause of death
Age-adjusted rate
No.
2005
2006
2007
2008
2009
2010
2011
Annualized % change†
2005
2006
2007
2008
2009
2010
2011
Annualized % change†
Diseases of the heart
216.8
205.5
196.1
192.1
182.8
179.1
173.7
652,091
631,636
616,067
616,828
599,413
597,689
596,577
% of total deaths
26.6%
26.0%
25.4%
25.0%
24.6%
24.2%
23.7%
Absolute difference§
-11.3
-9.4
-4.0
-9.3
-3.7
-5.4
-20,455
-15,569
761
-17,415
-1,724
-1,112
Relative difference¶
-5.2%
-4.6%
-2.0%
-4.8%
-2.0%
-3.0%
-3.54%
-3.1%
-2.5%
0.1%
-2.8%
-0.3%
-0.2%
-1.4%
Malignant neoplasms (cancer)
185.1
181.8
179.3
176.4
173.5
172.8
169.0
559,312
559,888
562,875
565,469
567,628
574,743
576,691
% of total deaths
22.8%
23.1%
23.2%
22.9%
23.3%
23.3%
22.9%
Absolute difference
-3.3
-2.5
-2.9
-2.9
-0.7
-3.8
576
2,987
2,594
2,159
7,115
1,948
Relative difference
-1.8%
-1.4%
-1.6%
-1.6%
-0.4%
-2.2%
-1.44%
0.1%
0.5%
0.5%
0.4%
1.3%
0%
0.6%
Female breast cancer
24.2
23.6
23.0
22.6
22.3
22.1
21.6
41,116
40,821
40,599
40,589
40,678
40,996
40,931
Colorectal cancer
17.7
17.4
17.0
16.6
16.0
15.8
15.3
53,252
53,549
53,586
53,321
52,394
52,622
52,287
Lung cancer
52.7
51.5
50.6
49.5
48.4
47.6
46.0
159,292
158,664
158,760
158,656
158,158
158,318
157,017
Chronic lower respiratory diseases
43.9
41.0
41.4
44.7
42.7
42.2
42.5
130,933
124,583
127,924
141,090
137,353
138,080
142,943
% of total deaths
5.3%
5.1%
5.3%
5.7%
5.6%
5.6%
5.7%
Absolute difference
-2.9
0.4
3.3
-2.0
-0.5
0.3
-6,350
3,341
13,166
-3,737
727
4,863
Relative difference
-6.6%
1.0%
8.0%
-4.5%
-1.2%
0.7%
-0.03%
-4.8%
2.7%
10.3%
-2.6%
0.5%
3.5%
2.0%
Cerebrovascular diseases (stroke)
48.0
44.8
43.5
42.1
39.6
39.1
37.9
143,579
137,119
135,952
134,148
128,842
129,476
128,932
% of total deaths
5.9%
5.7%
5.6%
5.4%
5.3%
5.2%
5.1%
Absolute difference
-3.2
-1.3
-1.4
-2.5
-0.5
-1.2
-6,460
-1,167
-1,804
-5,306
634
-544
Relative difference
-6.7%
-2.9%
-3.2%
-5.9%
-1.3%
-3.1%
-3.77%
-4.5%
-0.9%
-1.3%
-4.0%
0.5%
-0.4%
-1.7%
TABLE 1. Leading causes of death — United States, 2005–2011*
Cause of death
Age-adjusted rate
No.
2005
2006
2007
2008
2009
2010
2011
Annualized % change†
2005
2006
2007
2008
2009
2010
2011
Annualized % change†
Diseases of the heart
216.8
205.5
196.1
192.1
182.8
179.1
173.7
652,091
631,636
616,067
616,828
599,413
597,689
596,577
% of total deaths
26.6%
26.0%
25.4%
25.0%
24.6%
24.2%
23.7%
Absolute difference§
-11.3
-9.4
-4.0
-9.3
-3.7
-5.4
-20,455
-15,569
761
-17,415
-1,724
-1,112
Relative difference¶
-5.2%
-4.6%
-2.0%
-4.8%
-2.0%
-3.0%
-3.54%
-3.1%
-2.5%
0.1%
-2.8%
-0.3%
-0.2%
-1.4%
Malignant neoplasms (cancer)
185.1
181.8
179.3
176.4
173.5
172.8
169.0
559,312
559,888
562,875
565,469
567,628
574,743
576,691
% of total deaths
22.8%
23.1%
23.2%
22.9%
23.3%
23.3%
22.9%
Absolute difference
-3.3
-2.5
-2.9
-2.9
-0.7
-3.8
576
2,987
2,594
2,159
7,115
1,948
Relative difference
-1.8%
-1.4%
-1.6%
-1.6%
-0.4%
-2.2%
-1.44%
0.1%
0.5%
0.5%
0.4%
1.3%
0%
0.6%
Female breast cancer
24.2
23.6
23.0
22.6
22.3
22.1
21.6
41,116
40,821
40,599
40,589
40,678
40,996
40,931
Colorectal cancer
17.7
17.4
17.0
16.6
16.0
15.8
15.3
53,252
53,549
53,586
53,321
52,394
52,622
52,287
Lung cancer
52.7
51.5
50.6
49.5
48.4
47.6
46.0
159,292
158,664
158,760
158,656
158,158
158,318
157,017
Chronic lower respiratory diseases
43.9
41.0
41.4
44.7
42.7
42.2
42.5
130,933
124,583
127,924
141,090
137,353
138,080
142,943
% of total deaths
5.3%
5.1%
5.3%
5.7%
5.6%
5.6%
5.7%
Absolute difference
-2.9
0.4
3.3
-2.0
-0.5
0.3
-6,350
3,341
13,166
-3,737
727
4,863
Relative difference
-6.6%
1.0%
8.0%
-4.5%
-1.2%
0.7%
-0.03%
-4.8%
2.7%
10.3%
-2.6%
0.5%
3.5%
2.0%
Cerebrovascular diseases (stroke)
48.0
44.8
43.5
42.1
39.6
39.1
37.9
143,579
137,119
135,952
134,148
128,842
129,476
128,932
% of total deaths
5.9%
5.7%
5.6%
5.4%
5.3%
5.2%
5.1%
Absolute difference
-3.2
-1.3
-1.4
-2.5
-0.5
-1.2
-6,460
-1,167
-1,804
-5,306
634
-544
Relative difference
-6.7%
-2.9%
-3.2%
-5.9%
-1.3%
-3.1%
-3.77%
-4.5%
-0.9%
-1.3%
-4.0%
0.5%
-0.4%
-1.7%
Develop 2-line graph using Microsoft word or excel for the top 2 most common causes of death from an age category of your interest and report the "age and adjusted rate" trend of death occurrences for the period of 2005 through 2009 TABLE 2. Leading causes of death -United States, 2005-2011 No. Age-adjusted rate nnualized Annualized 2010 2011 2006 2007 2008 2009 |631.636 126.0% 20,455 Cause of death 200512006 |2007|20001200912010|2011 |616,828 125.0% |s99.413 |597,689 |s96,577 |616,067 125.4% 15,569 761 1.2.5% of the 652.091 16.8 ?196. 11192.11182.81179. 11173.7 heart 24.6% 24.2% 23.7% 17415 1,7241,112 2.8% 1.0.3% 1.0.2% 59,312 559,888 $62,875 565,469 67,628 574,743 576,691 22.8% 23. 1% 123.2% 22.9% 123.3% |23.3% 22.9% %of total desths Absolute 26,6% 3.7 -5.4 difference 1.4% Reletive fference 10.1% 3.1% 85.1181.8 179.3 176.4 173.5 172.8 1690 %Of total deaths 33 2.52.9 2.907 3.8 2,987 2,594 2,159 7.11s 1.94 1-1.4%|1.6%|-1.6%|-0.4%|-2.2% |-1.44% 0.1% (0.5% 4% 11.3% .8% 0.5% 41,116 40,821 40,599 40,589 40,67840,996 40,931 53,25253,549 53,586 3,321 52,39452,622 52,287 159.292 158,664 158,760 158,656 158,158 158,318 157,017 Female breast 24.21236 123.0 122.6 122.3?2.1?1.6 Colore tal concer 17.7 117.4 17.0 iss 1160 lisa liu 52.7 51.5 50.6 49.5 48.4 47.6 46.0 439 41.O 41.4 44.7 42.7 42-2 42.5 130.933 |124,583 |127,924 |141,090 |137,353 |138.080 |142.9 29 104 3.3 2.0 .5 0.3 .4113,166 3,737 727 4.5 42.1 96 39.1 37.9 143,579 |127,119 135,952 |134,148 125.842 129,476 128,932 diseases (stroke) %of total deaths 5.9% 5.7% 6,460 -1,167 1,8045,306 534 45% -09% |-1.3% -4.0% 0.5% -0.4% -1.7%Explanation / Answer
I developed the 2- Line graph in MS Excel for top 2 most common cause of death and attached the image of graph.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.