年龄组(D)死亡数2)人口数()人口构成比(4)死亡率(5一死亡数6 363726 =C4/C$10 =B4C4 30 63843 =C5/C$10=B5C5 105 47657 =C6/C$10 =B6C6 106 34282 =C7/CS10 60 =C8/C$10=B8C8 70~ 21468 =C9/CS10 =B9C9 =SUM(B4: B9) =SUM(C4 C =SUM(D4: D9)=Bl0/C10 =SUM(G: G
年龄组(1) A县 B县 死亡数(2) 人口数(3) 人口构成比(4) 死亡率(5) 死亡数(6) 0~ 26 363726 =C4/C$10 =B4/C4 24 30~ 77 63843 =C5/C$10 =B5/C5 77 40~ 105 47657 =C6/C$10 =B6/C6 106 50~ 89 34282 =C7/C$10 =B7/C7 86 60~ 71 23941 =C8/C$10 =B8/C8 56 70~ 35 21468 =C9/C$10 =B9/C9 24 合计 =SUM(B4:B9) =SUM(C4:C9) =SUM(D4:D9) =B10/C10 =SUM(G4:G9)
B县 年龄组 人口数(7 人口构成比(8) 死亡率(9) (1) H4/H$10 =G4/H4 72273 =H/H$10 =G/H5 45072 Hf6/H$10 =6H6 32371 H7H$10 18209 =H8/HS10 =G8/H8 11914 H9/H$10 =G9/H9 70~ SUM(H4: H9) =SUM(419 GIo/H1O
B县 年龄组 人口数(7) 人口构成比(8) 死亡率(9) (1) 409698 =H4/H$10 =G4/H4 0~ 72273 =H5/H$10 =G5/H5 30~ 45072 =H6/H$10 =G6/H6 40~ 32371 =H7/H$10 =G7/H7 50~ 18209 =H8/H$10 =G8/H8 60~ 11914 =H9/H$10 =G9/H9 70~ =SUM(H4:H9) =SUM(I4:I9) =G10/H10 合计
标准人口构成比(2)原死亡率分配死亡率(4 原死亡率 分配死亡率(6) C4+H4(sCS1O+SHs10)0.0007148=SM4*N4 0.00005857=SM4*Q4 =C5+H5(sCS1O+sHs10)0.00120608=SM5*N5 0.00106540=SM5*Q5 =C6+H6y(sC$lO+sHSl0)0.00220324=SM6*N6 0.00235179=SM6Q HC7+H7V(SCS10+$HS10)0.00259611=M7 N7 AM =(C8+H8/( SCS10+sHs10)0.00296562=SM8*N8 000307540=SM8°Q8 =(C9HH9y(SC$lO+SHs10)0.00163033=$M9*N9 0.00201443=SM9Q9 SUMM4: M9 0002623=SUMO4O90000269=SUMR4R
标准人口构成比(2) A县 B县 原死亡率 (3) 分配死亡率(4) 原死亡率 (5) 分配死亡率(6) =(C4+H4)/($C$10+$H$10) 0.000071482=3$7M9549*3N43402 0.000058579=7$3M4344*0Q90448 =(C5+H5)/($C$10+$H$10) 0.001206083=6$7M4051*2N815 0.001065404=7$8M4653*6Q035 =(C6+H6)/($C$10+$H$10) 0.002203244=0$1M4562*0N436 0.002351792=6$8M7265*5Q956 =(C7+H7)/($C$10+$H$10) 0.002596114=5$7M9077*9N47 0.002656698=8$9M7176*1Q047 =(C8+H8)/($C$10+$H$10) 0.002965623=8$2M5283*7N048 0.003075402=2$7M3680*0Q978 =(C9+H9)/($C$10+$H$10) 0.001630333=5$1M9695*7N169 0.002014436=7$9M7094*5Q499 =SUM(M4:M9) 0.000726234=7S3U42M03(4O944:O9) 0.000632699=8S9U83M94(8R442:R9)