Case study - Statistical Wheel of Fortune
Alex_Blackstone
Case4xls.xlsSheet1
| Wage Equity Statistical Score Sheet Blank | ||||||||
| Case 4 | ||||||||
| 1. Score sheet: | ||||||||
| Gender | Median Salary | Round 1 | Round 2 | Round 3 | End Balance | |||
| Female | $47,000 | |||||||
| Male | ||||||||
| Round | Roll | Men | Women | |||||
| 1 | 10 | 0 | ||||||
| 2 | 0 | -10 | ||||||
| 3 | 6% bonus | 4% Penalty | ||||||
| 4 | -10 | -15 | ||||||
| 5 | 3 | 2 | ||||||
| 6 | 3 | 2 |
Sheet2
| Degree | Men | Women | Difference | Per cent | |||
| HS | 1.4 | 1 | 0.4 | 3.5 | |||
| BS | 2.5 | 1.6 | 0.9 | 2.78 | |||
| MBA, masters | 4.8 | 2.9 | 1.9 | 2.5263157895 |
