Select Page

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.