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


IPUMS International error message - Page you were looking for doesn't exist
Is there a list of occupations with corresponding SEI scores attached, from t...
Question about IND1990 for not in the labor force
I am researching the city of Buxton, Iowa in 1910. How do I get data showing ...
When will ACS 2017 be available on IPUMS? (it has been released by Census)
Why are EARNWEEK and HOURWAGE not always consistent?
Login   |   Register

Recently Active Members

View More »

Share |