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
Post a Comment