4 ms·
These data are available in Excel format here: https://www.bls.gov/oes/current/oes_ca.htm https://www.bls.gov/oes/current/oes_ca.htm Click the link titled 'dow
by rahimnathwani 2y ago
These data are available in Excel format here: https://www.bls.gov/oes/current/oes_ca.htm https://www.bls.gov/oes/current/oes_ca.htm
Click the link titled 'downloadable XLS file'.
To get the 146% figure:
1. Filter AREA_TITLE for California
2. Filter OCC_TITLE for 'All Occupations'
3. Calculate A_PCT75 / A_PCT25 - 1
I'm a little suspicious of the data, though. I looked at every state and compared the value of:
A) A_PCT75 / A_PCT25 - 1 (Annual wage gap)
B) H_PCT75 / H_PCT25 - 1 (Hourly wage gap)
I expected the two numbers to be different, because many of the folks with a low annual wage are probably working part time due to family responsibilities, studies or whatever. But in every case, the two measures are the same, to within 0.1%.
On closer inspect, it turns out that the hourly wage isn't an hourly wage at all. For every single 'hourly wage percentile' column, the value is just the annual value divided by 2080.