Hello,
I am trying to reproduce data tables from the U.S. Census Bureau Equal Employment Opportunity (EEO) Tabulation. Some tables in this collection indicate the sample includes civilians who are 16 years and older. I am also reading through the technical documentation linked below. In my replications (I am using the 2013-2017 ACS 5-year data file, so I expect some discrepancies), I exclude military (using the two-digit occupational SOC code of 55), exclude people not in the labor force, and also exclude people younger than 16 years old. My estimate for the total workforce is 20 million over the estimates in Table EEO 1r, which estimates the total workforce to be 162,248,194 (2014-2018 ACS data). My estimate using 2013-2017 ACS data is 186,440,660. I am trying to figure out what I am doing wrong.
2014-2018 Equal Employment Opportunity Tabulation: Technical Documentation
I also exclude those with the empstatd values of 14 and 15 as those are non-civilians as well. Any insights as to how to reconcile my sample and the sample used in the eeo tables is greatly appreciated.
Thank you.