Case study - Statistical Wheel of Fortune

profileAlex_Blackstone
Case4Wordfile.docx

CASE 4: Statistical Wheel of Fortune: Women’s Edition--MMG 525.ON01 Summer 2018 © Turner. Statistical Decision Techniques for Managers.

Many court cases involving discrimination are decided on the basis of statistics. The usual question is ‘could the result (few women managers for example) be due to chance or is there a systemic bias in action that prevents member of a class (women, e.g.) from getting ahead?’ You will get to simulate chance via the roll of dice and apply your findings to a data base of information about salary inequities.

1. Take notes on each round-what was rolled on and the result from the appropriate chart.

2. Use Spreadsheet Score sheet to fill out this table. Put the dice roll results on the row Labeled ROLL. You can use the online Virtual Dice or a die (singular of dice).

3. Case 3: The Case Write up forms are posted in the Assignments Modules. There is a Word and Excel file or both. You download them, fill them out and post them to the assignment module. You are uploading two files. On the Word file, draw your own conclusion from the data you got comparing the two populations (Men and Women wage earners in Massachusetts) in terms of wage equity. You may find the PowerPoint from AAUW helpful on this. 

Gender

Median Salary

Round 1

Round 2

Round 3

End Balance

ROLL

Dice roll # here

Female

$47,000

ROLL

Dice roll # here

Male

$??

Questions:

1. If women earn 78.3% of males’ average annual salary in Mass., what is the average annual salary of males? Put the answer in the “Male” box above.

Background facts:

Mass was the first state to adopt an equal pay for men and women law, 70 years ago.

US Census

https://www.census.gov/prod/2002pubs/p23-210.pdf

Median Earnings over working lifetime of age 25-65 (40 years), in millions $.

Degree

Men

Women

Difference

HS

1.4

1.0

BS

2.5

1.6

MBA, masters

4.8

2.9

Dice roll URL:

https://www.random.org/dice/

Roll one die (singleton of dice) and record results.

Dice roll is:

Men

women

1. Finance Jobs

+$10,000

0

2. Service jobs

-$10,000

3. Child/care

6% bonus

4% penalty

4. Move to Wyoming

-10K

-15K

5. Ask for a raise

+3K

+2K

6. Higher Ed

+3K

+2K

2