年龄组(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)