Question

Status:Closed    Asked:Oct 24, 2014 - 09:28 AM

Calculating Median Earnings with March CPS: comparing to Census Tables

I am trying to reproduce the median earnings by sex tables published by the Census (Table P-20 (http://www.census.gov/hhes/www/income...). I am using stata and I am using the March CPS files appended over several years. My commands are:
collapse (p50) incwage [pw=wtsupp] if sex==1 & age>=25, by(year)
collapse (p50) incwage [pw=wtsupp ] if sex==2 & age>=25, by(year)

The medians I get are close (for most years) to the Census figures but not exact. Can this difference be explained?

Thanks.

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Tim_Moreland

Staff

I replicated the small differences that you are seeing between the microdata and published tables. We do not have an explanation for this difference, but this is very common when comparing microdata estimates and published statistics using CPS data. You could consider contacting the Census Bureau directly with your question.


I am sorry that I could not be of more direct assistance.

 

Oct 28, 2014 - 01:31 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

IRECODE1 Variable
homeless
Injury due to self-harm
How can I adjust the 5% sample of 1960 to 1%?
how i link individuals across different census? ie., look at one individual i...
Can I use replicate weights with non-ASEC samples? Should I?
Login   |   Register

Recently Active Members

View More »

Share |