Question

Status:Closed    Asked:Apr 05, 2017 - 03:32 PM

How do I create a measure of household income inequality from person-level data?

I am working with a person-level extract from the 2010 ACS. Included in my extract is the variable HHINCOME, which measures income at the household level -- and therefore is the same for every member of one household. What I want to do is create a measure of household income inequality that sums the total income of the top 5 percent of the distribution and divides that sum by the total income of the bottom 20 percent of the distribution. I want to create this measure for the dataset as a whole -- that is, a national estimate - and also create individual measures for the largest 100 metro areas. I have two questions related to this task. Number one -- it seems that if I do this calculation on the whole dataset I will be counting some household income values multiple times, so I need to somehow limit the universe. I think the way to do it is to select only those cases where PERNUM=1 and then do the sum calculation -- but would love confirmation of that. Two -- what do I do with weights here? Do I apply the household weights since I will only have one case from each household? To accurately calculate the sum it seems I need to multiply each HHINCOME by the associated weight before adding them together. I would appreciate any insight. Thanks!

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Jeff Bloem

Staff

Your intuition is correct on both questions. First, you are right that since you have multiple individuals per household in your dataset, you should limit your observations to only those with PERNUM==1. This will effectively ensure that only one observation per household exists in your dataset. Second, because you are using a household measure of income you'll want to use the HHWT variable in order to calculate nationally representative statistics.

I hope this helps.

 

Apr 06, 2017 - 08:41 AM

0
0
Report it

Answers

Fabulous -- thank you so much for your help. I just needed to confirm that I was thinking through it correctly!


 

Apr 06, 2017 - 06:10 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

sorry, i didn't see this in the FAQ/tutorials. i want to *just* download CPI...
The highest one percent incwage earners are combined into the incwage"Top Cod...
To compute unemployment rates from Ipums-I, should I use perwt as pweights or...
Why is the income wage variable incwage-capped? and how is the cap determined...
USA IPUMS 1980 ancestry variable -- mapping to country names
Did the version of database change since 2011?
Login   |   Register

Recently Active Members

View More »

Share |