HEB-0v Insert Draw Page Layout Formulas Data Review View {i glq'leU,Z,5_deaths Shape Format V 38 cut Calibri (Body) v l 11 . A- Av [: _ T. wrap Tex. Genera. . r V V V \\J__ V MK V n:- V E Amos\"... E3 Copy v W A 5 a a ; Fill v Paste U v v v v a Mar 9 & Center v v 0 '- " 1\" Condiliunal Format Cell Insert Delete Format 6 Farm\" B I \" 7 _ ' g $ / ) ' ' \"'0 ' Formatting as Table Styles 0 Clear ' TextBox 4 $ l r v A E C D E F G H l J K L M N D P Q R S T U V W X V 1 1010 Pnpllllhn (us census 2010): 301,105,531 The rutlonal eehner lnr Heallh sumcs traelcc health muscles and In chls problem val: wlll look I! monallty data nm 1010 (Holland! mummies nepam Vol. 61, Na. 4, MIV 0, 2013). PETER Ill Crude Pmpnninn bl ratal Death Rate 2 Rank cause 0! Death Number mal Deaths Deaths (1010) 3 M. a.\" u 5 pm"... mg m, a.) rhe cable [Wu you me mp 15 leldlnl auses of deaths and Jana] number otdeadls. rn culumn n combuce 4 1 Dim,\" a, ham 5975'9 the nan-whole mle ore-ch ofthese to the number or deaths hum III causes. anm as a declmalnu places. 5 2 M'HW'" "mm\" 57""3 IJ lh oulumn : rewme mls deamal as a pervehbase to one declmal place, nube that the column ls labeled 6 3 "WWW" \"WWWW\" \"'4'" 'renanr'sovau arelust movlnnhe declmalplac . 7 4 Cerebrovunulirdlseus 129 76 l 5 \"(idem (uninmlionzl iniuris} \"0'59 c.) In ulurrln F oomvube the crude duth rm ner 100,000 people usllll the population men. vaur formula 9 5 Alchemers alsaase 12,431 should compare the number of deaths to the populitlun and new In the 100000. 10 7 Dub\" mdlms 55,071 11 I "whmlsmwhmllc svndmmund nevhrosk 50:76 13 9 Iniluexl ind pnalmuniz 50,097 13 10 lnmdanalsefshaml (sulde) 3'35. 14 11 Sevllcemla 34111 15 12 Chroninlmrlssseind tlrmosh 3103 15 13 Bsmlial hypmsinn 2nd hyplmsive mil diam: 26,534 "adjusted Dh Hm Percent d.) In callunnsl I xthe cnc Ms 007\"qu the nan-twan ratlu burl-la dmhsla Full-II deaths ,7 u parkinmr, din,\" \"1,31 Charm: W foreach cause. hut-the van101m! ralla al 1.400 15mm to a Imal 0f 1.! given In column |.. mg' 7 . 3'39\"\" ll a formula dawn In Column lwhlch adds the was In Ealumnsl I I. 13 15 inmnllls 17,011 2010 7.010 Tml White 10 All ether causes 403,634 0.195 19.5 155: hank 147.0 -03 m 10 1A 1.2 Nest ln rallumn M we tan compute the actual number 11f deaths [sac each cause) fur Males uslhg the 20 3 175.1 .m 1.5 1,9 1.3 bamwhule ratla (columns: I L] and the aetual number 0f deaths In column 5. 21 2 172.1 474 1.4 1.0 1.2 11 3 \"2.2 _1-2 1.3 1,0 "-7 In Ollullln N mitt mmpl: the amal numhlr 1:713:3th (fut each (Ilse) In! Females. 23 4 35.1 1.3 1.0 1.0 1' 24 5 31.0 1.3 2.0 1.0 0.1 25 5 25.1 3.7 0.3 1.0 0.1 25 7 20.3 -1.0 1.4 1,0 2.0 17 I 15.3 1.3 IA 1!) 2.1 20 s 15.1 -0.5 M 1.0 1.1 29 10 12.1 2.5 4.0 1.0 0.4 30 11 10.5 4.6 1.2 1,0 2.0 31 12 9A 3.3 1.1 1.0 0.7 32 1a 1.0 2.5 1.0 1.0 u 33 14 6.1 4.6 2.3 1.0 0.4 3' 15 5-1 \"-1 1-5 1.0 "-5 e.) Whlch afthe lap 15 eeuaet ls must llluelyta havea rnale death versus: female death? Answer ls a 35 number 1 15. '5 a U 37 M05! "My mic cause: :2 l.) Whlch Mme has 15 causes 15 mass lllelyta have a black death versus awhlte death? Answer ls a number 1 > 15. 40 41 Most lllew bllck cause: 43 43 [J create a nlnh labeled pl. ehart shwlnl the top 5 till\": ufdaaths Ind lumpthe next ten causes M In wlch All orher. Libel with percent-us 0f the total. 45 45 e ' p #5 Deaths + Ready I El -u+ 85%
