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?

Science Epidemiology homework help