Question

actual simulated number starting salary (wm) number of number of starting of job job offers (Nm) starting job offers salary offers startng number of |salary (wf) job offers Nm% (wrn) (Nm) Nm% wm"Nm% NmB6wf*nm% Major Accounting 49,324 441 47,553 467 Accounting 49,324441 47553 Business Business administration 45,408 348 43,460 316 administration 45,408 348 43460 57,418 57418 Computer science 61,005 300 52 Computer science 61,005300 Chemical Chemical 246 65,984 engineering 65,389 186 engineering 65,389 246 65984 History 39,836 71 35,737 71 History 39,836 71 35737 Biological 33,708 83 33,766 Biologlcal sciences 33,708 83 33766 sciences 146 Mathematics 50,314 50314 48,868 53 48,868

1. calculate the % of men in each major to fill in the Nm% cells
2. calculate the % of women in each major to fill in the Nf% cells
3. compare the occupational profiles of men and women using your results from steps a) and b)
4. calculate the weighted average salary of men and women – to fill in the wm*Nm% and wf*Nf% cells respectively
5. compute the ‘raw’ gender pay gap by calculating the ratio of women’s to men’s average salary

1. Examine the influence of occupational segregation on the gender pay gap by calculating the pay gap that would obtain if women’s occupational profile was the same as men’s. To achieve this complete the following steps:

6. calculate the weighted average salary of women if their occupational profile was the same as men’s – to fill in the wf*Nm% cells
7. compute the adjusted gender pay gap by calculating the new ratio of women’s to men’s average salary

Answer 1

Simulated Women Women Starting Number of Starting Number of Starting Number of Starting Number of Job | Nm96Iwm+nm% Salary | Job (wm) offers(Nm) (wf) offers(Nf) (wm) offers(Nm) (wf offers(Nf) 28.77961 14189.10 | 47553 36.17%17201.59 Accountin 28.77% | 14189.10| 47553 28.77% 13679.63 Accountin 49324 49324 441 Business Business 22.70% 19865.675 Administration 45408 348 22.70% 10307.88 43460 316 | 24.48% | 10637.77|Administration | 45408 22.7096 | 10307.88| 43460 316 Computer Computer 9.57% 11938.36 57418 4.03% | 2312.73 |Science 19.57% | 11938.36| 57418 19.57% | 11236.4 Science 61005 300 61005 Chemical 16.0596| 10492.95 | б5984 14.41% | 9506.60 |Engineerin 16.05% | 10492.95| 16.05% | 10588.43 Engineerin 65389 246 65 389 246 65984 186 4.63% | 1844.98 | 35737 5.50% | 1965.40 Histo 4.63% | 1844.98| 35737 4.63% |1655.138 Histo 39836 71 71 39836 71 Biological Biological | 1828.166 33708 5.41%| 1825.03 | 33766 146 11.31% | 3818.62 |Science 33708 5.41% | 1825.03 33766 5.41% Science 146 2.8796 | 1444.107 Mathematics 2.87961 1402.60 | 50314 4.11% | 2065.56 |Mathematics 2.87%1402.60 50314 53 Total 1533 1291 1291 1533 c) from the results of a &b, it can be seen that number of job offers are high for men as compare to women but women are having the higher weighted average salary in most of the majors as compare to men. e) Calculation of Raw gender Ratio of women's to men's average sala Ratio Iwm+nm% wf"nf96 | Difference | Pay Ga 467 1.06 | 14189.10 | 17201.59| -3012.49 | -21.23% Accountin 441 0.91 | 10307.88|10637.77| -329.89 | -3.20% Administration 316 Computer 0.17 | 11938.36| 2312.73| 9625.62 | 80.63% Science 300 Chemical 9.40% Engineering 246 18б 0.76 10492.95 9506.60

71 Histo 71 1.00 1844.98 1965.40120.42 6.53% Biological 83 146 1.76 | 1825.03 | 3818.62 | -1993.59 |-109.24% Science Mathematics 1.20 | 1402.60 | 2065.56| -662.96 |-47.27% 53 Calculation of Adiusted gender pay ga Ratio of women's to men's average sala Adjusted gender p Major Ratio |wm *nm% wf*nm%, Difference | Pay Gap Nm Nf 441 3.59% Accountin 467 1.06 14189.10 13679.63509.47 BusinesS 316 | 4.29% Administration 348 0.91 10307.88 9865.68 442.21 Computer 52 5.88% Science 300 0.17 11938.36 11236.40 701.96 Chemical 246 95.48 |-0.91% Engineering 186 0.76 10492.95 10588.43 71 71 1.00 | 1844.98 | 1655.14 | 189.84 | 10.29% Histo Biological 83 146 3.14 -0.17% Science 1.761825.03 1828.17 Mathematics -2.96% 53 1.20 1402.60 1444.11 -41.50