BUS 308 Week 2 Problem Set Answers / STATISTICS FOR MANAGERS

BUS 308 Week 2 Problem Set Answers / STATISTICS FOR MANAGERS



BUY HERE⬊


BUS 308 STATISTICS FOR MANAGERS Week 2 Problem Set Answers (2019)
ID
Salary
Compa-ratio
Midpoint 
Age
Performance Rating
Service
Gender
Raise
Degree
Gender1
Grade




1
58,5
1,027
57
34
85
8
0
5,7
0
M
E

The ongoing question that the weekly assignments will focus on is:  Are males and females paid the same for equal work (under the Equal Pay Act)?  







2
27,4
0,885
31
52
80
7
0
3,9
0
M
B

Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work.







3
36,2
1,169
31
30
75
5
1
3,6
1
F
B









4
61,3
1,075
57
42
100
16
0
5,5
1
M
E

The column labels in the  table mean:







5
47,2
0,984
48
36
90
16
0
5,7
1
M
D

ID – Employee sample number


Salary – Salary in thousands    




6
74,2
1,108
67
36
70
12
0
4,5
1
M
F

Age – Age in years


Performance Rating - Appraisal rating (employee evaluation score)




7
43
1,074
40
32
100
8
1
5,7
1
F
C

Service – Years of service (rounded)


Gender – 0 = male, 1 = female  




8
24,1
1,046
23
32
90
9
1
5,8
1
F
A

Midpoint – salary grade midpoint    


Raise – percent of last raise




9
76,6
1,143
67
49
100
10
0
4
1
M
F

Grade – job/pay grade


Degree (0= BS\BA 1 = MS)




10
23,2
1,009
23
30
80
7
1
4,7
1
F
A

Gender1 (Male or Female)


Compa-ratio - salary divided by midpoint




11
23,3
1,011
23
41
100
19
1
4,8
1
F
A









12
59,6
1,045
57
52
95
22
0
4,5
0
M
E









13
42,3
1,058
40
30
100
2
1
4,7
0
F
C









14
22
0,957
23
32
90
12
1
6
1
F
A









15
21,4
0,932
23
32
80
8
1
4,9
1
F
A









16
45,4
1,136
40
44
90
4
0
5,7
0
M
C









17
71,6
1,257
57
27
55
3
1
3
1
F
E









18
34,3
1,105
31
31
80
11
1
5,6
0
F
B










Comments