Problem Set 3: Standardization of rates and spreadsheet skills
Objectives:
To calculate agespecific and crude death rates using a spreadsheet program.
To describe the age pattern of mortality and age distribution, and to understand how they each affect the crude death rate.
To perform and interpret results of an age standardization of mortality rates.
To learn basic spreadsheet skills of data entry and programming.
I recommend that you complete steps 1 through 4 during the first week after the assignment has been introduced, and steps 7 and 8 in the second week. Steps 5 and 6 could be done either week, but must precede steps 7 and 8.
1) Data entry and basic calculations (20 points).
e. total number of persons (all ages, both sexes, all races) in the United States
2) Be sure to use consistency checks to make sure the proportions and rates you have calculated follow expected patterns and are internally consistent (see class notes on classification and on mortality rates).
3) Print out your spreadsheet and write the row labels (#s) and column labels (letters) (5 points)
4) Formulas (10 points) Hand write the formulas on the bottom of your spreadsheet.
5) Age pattern of mortality (15 points)
Use Excel to create a line graph showing mortality rates by age for black females. Include a title and labels for the x and yaxes.
Print out the chart.
Does the age pattern of mortality correspond to what we have learned in class?
6) Age distributions (15 points)
7) Age standardization (20 points)
8) Interpretation of standardized and unstandardized rates (15 points)
Number of persons and number of deaths by fiveyear age group, black females, United States, 1997 

Age group (years) 
Black females 
All racial groups, both sexes 

# of deaths 
1000s of persons 
1000s of persons 

<1 
3786 
295 
3881 
14 
587 
1151 
15353 
59 
445 
1550 
19738 
1014 
369 
1444 
19040 
1519 
713 
1457 
19068 
2024 
1004 
1313 
17512 
2534 
3805 
2827 
39610 
3544 
8302 
2892 
43998 
4554 
11547 
1956 
33633 
5564 
16379 
1253 
21813 
6574 
26241 
958 
18499 
7584 
30856 
544 
11706 
85 and older 
28348 
207 
3871 
Total 



Back to epidemiology syllabus.
Back to home page for Prof. Miller
Last updated 11/25/02. Jane Miller.