Question

Complete the following table

	US Death Rate per 100,000	Population		Expected Deaths
		Alaska	Florida	Alaska	Florida
<5	21.2	60,000	812,000	A	F
5-44	33.6	368,000	6,543,000	B	G
45-64	35	78,000	2,528,000	C	H
65+	86.6	19,000	2,140,000	D	I
Total	39	525,000	12,023,000	E	J

-A.B.C.D.E.F.G.H.I.J.	Expected Deaths A
-A.B.C.D.E.F.G.H.I.J.	Expected Deaths B
-A.B.C.D.E.F.G.H.I.J.	Expected Deaths C
-A.B.C.D.E.F.G.H.I.J.	Expected Deaths D
-A.B.C.D.E.F.G.H.I.J.	Expected Deaths E
-A.B.C.D.E.F.G.H.I.J.	Expected Deaths F
-A.B.C.D.E.F.G.H.I.J.	Expected Deaths G
-A.B.C.D.E.F.G.H.I.J.	Expected Deaths H
-A.B.C.D.E.F.G.H.I.J.	Expected deaths I
-A.B.C.D.E.F.G.H.I.J.	Expected Deaths J

A.	5108
B.	2198
C.	123.6
D.	16
E.	179.3
F.	1853
G.	12.7
H.	885
I.	172
J.	27

Answer 1

Sample calculation:

Expected deaths in age<5 in Alaska = Death per 1,00,000 x Population / 1,00,000 = 21.2 x 60,000/100,000 = 12.7

Similarly, completing other calculations on excel