代做SAR HS 300 Epidemiology Assignment 2 Mortality Rates Fall 2024代做留学生SQL语言

2024-09-18 代做SAR HS 300 Epidemiology Assignment 2 Mortality Rates Fall 2024代做留学生SQL语言

SAR HS 300 Epidemiology

Homework Assignment 2: Mortality Rates

Fall 2024

PLEASE ROUND ALL DECIMAL RATES (NOT PERCENTS) TO 6 DECIMAL PLACES

1. Direct Age Adjustment

a. Use Tables 1 & 2 to calculate New York 2020 direct age adjusted mortality rate. Use the overall US Population age distribution for 2020 as the Standard Population (Table 2). For age-specific deaths rates, fill in all columns in Tables 1 & 2, rounding age specific mortality rates to 6 decimal points (25 points)

Table 1: All-Cause Mortality by Age Group in New York, 2020

Age

Category

NY Population, 2020

Deaths

Age-specific Mortality Rate (to 6 decimal places)

0-24

5,710,239

2,658

0.000465

25-44

5,268,761

8,955

0.001700

45-64

4,988,207

35,681

0.007153

65+

3,369,569

156,088

0.046323

TOTAL

19,336,776

203,382

 

 

Table 2: Direct Age Adjustment of New York Mortality Rate to US Standard Population

Age Category

2020 US Population

(A)

2020 NY Mortality Age-Specific Rate

(B)

(A) X (B) = (C)

(round to 2 decimal places)

0-24

104,360,763

0.000465

48527.75

25-44

87,018,803

0.001700

147931.97

45-64

84,277,214

0.007153

602834.91

65+

55,792,501

0.046323

2584476.02

TOTAL

331,449,281

0.055641

3383770.65

b. The age adjusted mortality rate (per 100,000) for New York in 2020 was: (15 points)

48527.75 + 147931.97 + 602834.91 + 2584476.02 = 3383770.65

3383770.65 / 331449281 * 100000 = 1020.901 per 100000

c. Calculate crude mortality rate (per 100,000) in New York in 2020 (5 points)

203382 / 19336776 * 100000 = 1051.789 per 100000

d. Explain the difference between the crude and age adjusted mortality rates for New York in 2020. (15 points)

The crude mortality rate does not account for age distribution, but the age-adjusted mortality rate does. Age-adjusted mortality accounts for the population's age distribution, allowing for comparisons between groups.

The two rates differ because New York's population is more likely to be older than the national average. The crude rate (1051.789 per 100000) is greater since it represents the actual number of deaths, but the age-adjusted rate (1020.901 per 100000) accounts for age differences and is slightly lower.

a. There were 4,383,729 total deaths in the United States in 2020. The crude mortality rate (per 100,000) for the US in 2020 was: (5 points)
4383719 / 331449281 * 100000 = 1322.591

b. Calculate the Direct Standardized Mortality Ratio (DSMR) for New York in 2020: (5 points)

1051.789 / 1020.901 = 1.030

c. Write a statement to interpret your DSMR result in b) above (5 points)
A DSMR of 1.03 indicates that the crude mortality rate in New York in 2020 is 3% higher than the age-adjusted mortality rate.

3. In 2021, Portland, a community with a population of 1,500,000 experienced 11,840 deaths. 1,538 of these deaths were due to COVID-19.

a. Calculate the crude mortality rate per 100,000 in Portland in 2021 (5 points)

11840 / 1500000 * 100000 = 789.333 per 100000

b. Calculate the cause specific mortality rate per 100,000 from COVID-19 in Portland in 2021 (5 points)  

1538 / 1500000 * 100000 = 102.533 per 100000

c. Calculate the proportional mortality ratio (PMR) from COVID-19 in Portland in 2021 (5 points)

1538 / 11840 *100% = 12.99%

4. You are provided further information on Portland. 60,000 residents were aged 20-29 years of age. Among this age group, there were 233 deaths, of which 79 were due to COVID-19.

a. What was the age specific mortality rate per 100,000 among the 20-29 years age group in Portland? (5 points)

Age specific mortality rate = 233 / 60000 * 100000 = 388.333 per 100000

b. What is the cause specific mortality per 100,000 due to COVID-19 among the 20-29 years age group in Portland? (5 points)

Cause specific mortality rate = 79 / 60000 * 100000 = 131.667 per 100000