Presentation Title (Limit of 12 words)

Vertical Equity Analysis using the Gini Coefficient in Excel

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

This document is currently not available here.

Share

COinS
 
Aug 30th, 4:15 PM Aug 30th, 5:15 PM

Vertical Equity Analysis using the Gini Coefficient in Excel

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.