In this exercise, we will be exploring how to calculate crude mortality, age-specific mortality, and direct age-adjustement. This exercise will require you to have access to demographic data from American FactFinder. Please 

work on the morbidity assignment prior to tackling this assignment. I am going to assume you already know how to use Excel formulas, as they were used extensively in the morbidity tab.

As with the previous tab, I will provide you examples. Remember:

Age Specific Mortality (ASR): Total Died in that Age Category/Total in that Age Category x 100,000

Crude Mortality Rate: All deaths/Total Population x 100,000

Age-adjustment is odd, you have to calculate the ASR first and not multiply it by 100,000. Then you multiply it by a standard population, or a population you are attempting to compare it to.

 

Now if you look at the ASR, you will see that clearly 55+ have the highest age specific rate. However, remember that population covers a lot of people and can be prone to a high rate or mortality already.

Calculating an age specific adjustment be useful to see if the crude rate increases or decreases.

 

Example 1: Crude Mortality Rate & Age Specific Rate (ASR)
Age Group Deaths Total Population ASR
0 – 14 4 231,158 1.73
15 – 19 23 73,200 31.42
20 – 34 500 231,158 216.30
35 – 54 250 231,158 108.15
55+ 1000 211,895 471.93
Total 1777 978,569