Good afternoon IPUMS community,
I’m working on a project that examines janitors (OCC code 7690) in the Miami-Fort Lauderdale-West Palm Metro area. I’m using ACS five year data, 2013-2017. I’m limited to working in excel.
For starters, I’m trying to replicate some basic tables produced by the census, to make sure I’m doing things correctly.
I’m having trouble recreating ACS Table C24050: Industry by occupation for civilian employed population above age 16.
In my IPUMS excel table, I’m summarizing PERWT to obtain an estimate of workers in all industries. I’m excluding industry code 0, which eliminates persons less than 16 years old/unemployed who never worked/NILF who last worked more than 5 years ago, as well as industry codes 9670-9920, representing military and unemployed persons.
My result is 3,408,762 observations, significantly larger than ACS’ 2,858,792 estimate, and well outside it’s MOE.
Do folks have advice in terms of what mistakes I’m making? Do I need to divide by a certain amount given that I’m summarizing data for all five years? Is it incorrect to simply sum PERWT? Any advice would be appreciated. Thank you!