I am working on a excel spreadsheet trying to figure standardized age rates. I have a question about the totals on E7, E12, H7 and H12. The total for E7 that I obtained is 55/20,000 x 1000 = 2.75 rounded to 2.8. My question is, am I working this out correctly? or does that total have to equal the sum of the column E which would be 1.4 +1.5 +10 = 12.9 ? For the grand total I have 2.93 on E14 which I obtained by 69/23500 x 1,000 = 2.93, is that correct or should I be adding 2.8 + 4.0 to get the total for E14?
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. |
