Science Epidemiology homework help

CeciliaR
Question10formCompleted.xlsx

Sheet1

Region A Region B Age Standard Population Region A Risk/1,000 Expected Cases Region A Region B Risk/1,000 Expected Cases Region B
Age No. of Cases Female Population Risk/ No. of Cases Female Population Risk/ < High School Education 40-50 22,000 1.4 0.6 0.7 0.0
1,000 1,000 51-60 15,000 1.5 0.1 4.0 0.3
< High School Education 40-50 10 7,000 1.4 10 15,000 0.7 >61 58,000 10.0 0.2 10.9 0.2
51-60 15 10,000 1.5 20 5,000 4.0 Total 95,000
>61 30 3,000 10.0 600 55,000 10.9 Adjust< HS
Total 55 20,000 2.8 630 75,000 8.4 >= High School Education 40-50 3,000 3.0
51-60 17,000 2.5 0.7
≥ High School Education 40-50 5 1,000 5.0 6 2,000 3.0 >61 1,500 8.0 4.0
51-60 5 2,000 2.5 10 15,000 0.7 Total 21,500
>61 4 500 8.0 4 1,000 4.0 Adjust>HS
Total 14 3,500 4.0 20 18,000 1.11`
Grand Total 116,500
Grand Total 69 23,500 2.93 650 93,000 6.9 Adjusted Rate/1000
Crude Rate 2.9 6.9
 On the <HS education, for example, I calculated a total risk in region A of 2.75/1000. 

Sheet2

Sheet3