Figure C.1. Estimation steps for Medicaid spending on diabetes care

Text Description

Flowchart showing the estimation steps for Medicaid spending on diabetes care. An arrow on the left goes from the top of the page to the bottom and indicates sections, Original Source Data, Adjustments, and Final Estimate. The first box has two sections, Diabetes prevalence 2002 greater than 20 years old and Diabetes prevalence 2002 greater than 60 years old. The box has a down arrow to the next step, Calculate national diabetes prevalence 2002 20 to 60 years old and greater than 60 years old.

Next to the first box is a box that says "Diabetes prevalence by race 2002 greater than 20 years old." It has a down arrow to the next step, Assume age proportion is the same across race subgroups and apply proportion to each subgroup, which is also the step after Calculate national diabetes prevalence 2002 20 to 60 years old and greater than 60 years old. The next step is Diabetes prevalence by race 2002 20 to 60 years old and greater than 60 years old. The next step is Apply diabetes prevalence by race and age, 2002, to the Medicaid population, by race and age, 2002, and aggregate to Medicaid population. The next step is Diabetes prevalence in the Medicaid population, 2002, 20 to 60 years old and greater than 60 years old. The final step is Medicaid spending for diabetes, 2002, greater than 20 years old.

Another set of steps begins with a box with two sections, Medicaid population by age 1998 and Medicaid population by race 1998. This leads to the step Define age of population segment and assume proportion is the same across race subgroups and apply to each subgroup. The next step is Medicaid population by race 1998 20 to 60 years old and greater than 60 years old. The next step is Apply proportion increase from 1998 to 2002 to each race subgroup for 1998, 20 to 60 years old and greater than 60 years old. The next step is Medicaid population by race 2002 20 to 60 years old and greater than 60 years old. The next step is Apply diabetes prevalence by race and age, 2002, to the Medicaid population, by race and age, 2002, and aggregate to Medicaid population. The next step is Diabetes prevalence in the Medicaid population, 2002, 20 to 60 years old and greater than 60 years old. The final step is Medicaid spending for diabetes, 2002, greater than 20 years old.

Another set of steps begins with a box with two sections, Medicaid enrollment 1998 and Medicaid enrollment 2002. The next step is Apply proportion increase from 1998 to 2002 to each race subgroup for 1998, 20 to 60 years old and greater than 60 years old. The next step is Medicaid population by race 2002 20 to 60 years old and greater than 60 years old. The next step is Apply diabetes prevalence by race and age, 2002, to the Medicaid population, by race and age, 2002, and aggregate to Medicaid population. The next step is Diabetes prevalence in the Medicaid population, 2002, 20 to 60 years old and greater than 60 years old. The final step is Medicaid spending for diabetes, 2002, greater than 20 years old.

The last box across the top row is Per capita medical expenditures for people with diabetes, 2002, which leads directly to Medicaid spending for diabetes, 2002, greater than 20 years old.

Return to Document
Return to Contents