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 ( 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?


Do you have the same question? Follow this Question

Staff Answer




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

Report it


Change in CPS EMPSTAT (A-LFSR Labor force status recode) in 2001?
I have an extract 2001 to 2015. Total number of people: 4 million, but in bir...
Why are there fewer counties in the 1950 1% sample compared to the 1940 1% sa...
Is the value of INCWKCOM included in the value of INCDISAB?
Trying to access CPS online analysis tool
ACS METRO variable construction
Login   |   Register

Recently Active Members

View More »

Share |