Presentation Category
08 OVERSIGHT AND COMPLIANCE REVIEW
Session Description
Using Excel, we introduce a new measure for vertical equity based on the Gini Coefficient, a widely used index to determine the regressivity or progressivity of social programs pervasive in the economic and public health literature. As applied to property assessments, we illustrate how the index is calculated, how the inequality curves are visualized, and how statistical testing for vertical equity is formulated.
Audience Expertise
Intermediate (Ideal for the participant with a general knowledge within the areas covered.)
Start Date
8-30-2021 4:15 PM
End Date
8-30-2021 5:15 PM
Vertical Equity Analysis using the Gini Coefficient in Excel
Grand Hall L
Using Excel, we introduce a new measure for vertical equity based on the Gini Coefficient, a widely used index to determine the regressivity or progressivity of social programs pervasive in the economic and public health literature. As applied to property assessments, we illustrate how the index is calculated, how the inequality curves are visualized, and how statistical testing for vertical equity is formulated.
