Status:Closed    Asked:Feb 21, 2017 - 12:27 PM

How can I transform the incwt variable into a percentage to calculate weighted averages?

I need to calculate averages conditioned on year and occuupation using the weight variable incwt so that they are representative. How do I use this weight in calculating averages? Can it be transformed into a percentage?

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


I think you are referring to EARNWT. If not, feel free to clarify. If your aim is to calculate income by year and occupation, it may be better to use the INCTOT variable within the ASEC samples and use the PERWT weighting variable. You can learn more about sampling weights by reviewing this IPUMS-CPS FAQ page. For some occupations, due to the relatively small sample in the CPS and the large number of occupation categories, it may be difficult to calculate meaningful summary statistics using public use data. One option around this difficulty would be to aggregate some occupations together so you have a smaller number of occupation categories. Finally, the BLS puts out a table every year with national occupational employment and wage estimates. Here is a link to the table for 2015.

I hope this helps.


Feb 22, 2017 - 07:42 AM

Report it


How do I find the data file:Ipumsi_00001.dat for the 1974
Just a note that the release schedule for IPUMS USA and FAQ funding are out o...
Variables from Full Year Consolidated Files currently not included in IPUMS-M...
Wrong HH weight Tanzania 2012 census?
Assign Individuals to PUMAS, append dataset
Regarding: Does CLASSWKR in ASEC before 1988 include incorporated and non-inc...
Login   |   Register

Recently Active Members

View More »

Share |