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


Does anyone have sample code for using svydesign function in R?
Which variables should I use in my data extract for determining father-son pa...
What "Psychiatric, Nursing, and Home health aid" occ 3600 encompasses?
Difference in Sample Size between ACS 2016 and Census Technical Documentation...
Incomplete alphabetic variable list and broken IPUMS group table in thee CPS.
What R package is needed for IPUMS USA for weighting? Is it "survey"? Do you ...
Login   |   Register

Recently Active Members

View More »

Share |