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 womens to mens average salary

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

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

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