Practical Workshop on Measuring Inequality: Theory & Techniques in San Jose, Costa Rica
190 likes | 318 Views
Join us for an engaging workshop focusing on the theory and practical techniques for measuring inequality, held on August 4-5, 2004, in San Jose, Costa Rica. This panel session, led by experts James K. Galbraith and Enrique Garcilazo from the University of Texas Inequality Project, emphasizes calculating the Theil index through hands-on training with programs and macros. Topics will include data collection methods, hierarchical classifications, and Theil component analysis, equipping participants with vital skills for assessing economic disparities.
Practical Workshop on Measuring Inequality: Theory & Techniques in San Jose, Costa Rica
E N D
Presentation Transcript
Measuring Inequality A practical workshop On theory and technique San Jose, Costa Rica August 4 -5, 2004
Panel Session on: Mechanics to Calculate the Theil and Use of Programs and Macros
by James K. Galbraith and Enrique Garcilazo The University of Texas Inequality Project http://utip.gov.utexas.edu Session 3
Outline • Two hierarchical level grouping • Data Collection • Between Group Theil • Within – Group Theil • Programs and Macros • Working with Output – Analysis
Two Level Hierarchical grouping • Data typically given by geographical units and several sectors within each unit • The between group component • The within group component
Collecting data • Variables: • #1 Compensation earned – wages • #2 Number of people earning – employees • Two sets of data • Equal number of observations for each data set • Making sure there are no zeros • Arrange data into a yearly matrix of columns and rows (columns are geographical units, rows sectors)
Data Management • Sectors = {a, b, c} • Geographical units = {1, 2, 3} • Check: • matching # observations between both matrixes • non zero observations
Cleaning The Data • Compare both data-bases and look for missing observations • count function in Excel • Compare # of observations in rows and columns • Take out observations equal to zero • If the database is time series, make sure that the number of industries included in the analysis is consistent through time
Calculating The Between Theil • The between component can be expressed by two equivalent equations: • First equation – more intuitive • Second equation – easier to calculate
Calculating The Between Theil • Add across rows and columns
Calculating The Between Theil • Using natural logs instead of base 10 • Interpreting the between components • Positive component means the group is above the mean • Negative component means it is below the mean • Make sure the sum of all components (between Theil) is positive and inside a reasonable range • Between Theil used as estimate of total Theil
Calculating The Within Theil • First: Calculate the unweighted within Theil in each group (among p individuals/groups) • Calculate the Theil by sector or by region • The unweighted Theil is the total Theil for the group in the second hierarchical level
Calculating The Within Theil • Second - multiply the unweighted within Theil component by the income weight of each group • Third – take the sum of all the individual components to obtain the weighted within Theil
Output • For a given year obtain: • Total Theil • Between group Theil • Weighted within group Theil • Interpreting the individual between Theil components • The unweighted within group Theil component interpreted as the total Theil in the 2nd hierarchical level
Programs and Macros • Excel Spreadsheet • Stata program • SAS options