Status:Closed    Asked:Mar 20, 2017 - 10:45 PM

Getting race and gender percentages by detailed occupation by year

I'm trying to recreate this 2016 table, except with more detailed breakdowns of race and gender:

For example, instead of separate categories for Women and Race, I'd like to create percentages for "White women," "Black women," "Asian women," and "Latina women," too.

The trouble I'm having is with weighing the data. As far as I know, in order to get the percentage of a group in weighted survey data, I need to sum the WTSUPP of the group I'm looking at and divide by the sum WTSUPP of the entire sample.

So, to make sure I was on the right track, I decided to compare the female percent of IPUMS' data set with BLS for "Healthcare support occupations" (occupation code 3600-3655). I summed up the WTSUPP of just the female rows and divided by the sum WTSUPP of all the rows (female and male). But my result appear to be off from the BLS by about 0.3% (BLS says 87.7% women, my result was 88%). Is there any reason why this would be happening? This is on year 2016 data, so I'm not sure if it's affected by updates to weights. I'd also love to know if I'm doing this all wrong!

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


It sounds like you are performing the weighting of the data correctly. It doesn't look like your estimates are that far off of the official BLS estimates. In general, we don't expect to exactly replicate official statistics. So it looks like your estimates are well within the margin of error of the BLS estimates, so I wouldn't worry too much about your methodology.


Mar 21, 2017 - 10:28 AM

Report it


There is no oberservation for same individual between 1976 December and 1977 ...
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)
Login   |   Register

Recently Active Members

View More »

Share |