Status:Closed    Asked:Jul 26, 2018 - 05:26 PM

Weighted average for hours worked by occupation?

I am calculating average hours per workweek by occupation using 2016 ACS data for Oregon, employed workers only. That is, UHRSWORK for each OCC, where STATEFIP = 41 & EMPSTAT = 1.

I created a weighted average. I multiplied each person's hours by PERWT, then summed these amounts for each occupation. Finally, I divided these totals by the total of PERWTs in each occupation.

Is this a good approach?

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


Yeah, although not seeing exactly the steps in this calculation, this sounds like a good approach. One way you can verify if you've done everything correctly, is to use the IPUMS USA online analysis tool. Since the statistics you are producing are relatively straightforward, you will be able to calculate these statistics using this tool. This might be a good idea, since even if your approach is correct, small errors can sometimes lead to big differences.


Jul 27, 2018 - 09:10 AM

Report it


interpretation of the weighted average using WT06
Why are not all the "not in the labour force" categories filled for the EMPST...
Occupation by MSA
empstat and occ1990 - Not in labor force, but still reporting an occupation?
Login   |   Register

Recently Active Members

View More »

Share |