|
See comments at the right of the data set.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ID
|
Salary
|
Compa
|
Midpoint
|
Age
|
Performance Rating
|
Service
|
Gender
|
Raise
|
Degree
|
Gender1
|
Grade
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8
|
23
|
1.000
|
23
|
32
|
90
|
9
|
1
|
5.8
|
0
|
F
|
A
|
|
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)?
|
|
10
|
22
|
0.956
|
23
|
30
|
80
|
7
|
1
|
4.7
|
0
|
F
|
A
|
|
Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work.
|
|
|
|
|
|
|
11
|
23
|
1.000
|
23
|
41
|
100
|
19
|
1
|
4.8
|
0
|
F
|
A
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14
|
24
|
1.043
|
23
|
32
|
90
|
12
|
1
|
6
|
0
|
F
|
A
|
|
The column labels in the table mean:
|
|
|
|
|
|
|
|
|
|
|
|
15
|
24
|
1.043
|
23
|
32
|
80
|
8
|
1
|
4.9
|
0
|
F
|
A
|
|
ID – Employee sample number
|
Salary – Salary in thousands
|
|
|
|
|
|
|
|
23
|
23
|
1.000
|
23
|
36
|
65
|
6
|
1
|
3.3
|
1
|
F
|
A
|
|
Age – Age in years
|
|
Performance Rating – Appraisal rating (Employee evaluation score)
|
|
|
|
|
26
|
24
|
1.043
|
23
|
22
|
95
|
2
|
1
|
6.2
|
1
|
F
|
A
|
|
Service – Years of service (rounded)
|
Gender: 0 = male, 1 = female
|
|
|
|
|
|
|
|
31
|
24
|
1.043
|
23
|
29
|
60
|
4
|
1
|
3.9
|
0
|
F
|
A
|
|
Midpoint – salary grade midpoint
|
Raise – percent of last raise
|
|
|
|
|
|
|
|
|
35
|
24
|
1.043
|
23
|
23
|
90
|
4
|
1
|
5.3
|
1
|
F
|
A
|
|
Grade – job/pay grade
|
Degree (0= BS\BA 1 = MS)
|
|
|
|
|
|
|
|
|
36
|
23
|
1.000
|
23
|
27
|
75
|
3
|
1
|
4.3
|
1
|
F
|
A
|
|
Gender1 (Male or Female)
|
Compa - salary divided by midpoint
|
|
|
|
|
|
|
|
37
|
22
|
0.956
|
23
|
22
|
95
|
2
|
1
|
6.2
|
1
|
F
|
A
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
42
|
24
|
1.043
|
23
|
32
|
100
|
8
|
1
|
5.7
|
0
|
F
|
A
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3
|
34
|
1.096
|
31
|
30
|
75
|
5
|
1
|
3.6
|
0
|
F
|
B
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18
|
36
|
1.161
|
31
|
31
|
80
|
11
|
1
|
5.6
|
1
|
F
|
B
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
20
|
34
|
1.096
|
31
|
44
|
70
|
16
|
1
|
4.8
|
1
|
F
|
B
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
39
|
35
|
1.129
|
31
|
27
|
90
|
6
|
1
|
5.5
|
1
|
F
|
B
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7
|
41
|
1.025
|
40
|
32
|
100
|
8
|
1
|
5.7
|
0
|
F
|
C
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13
|
42
|
1.050
|
40
|
30
|
100
|
2
|
1
|
4.7
|
1
|
F
|
C
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
22
|
57
|
1.187
|
48
|
48
|
65
|
6
|
1
|
3.8
|
0
|
F
|
D
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
24
|
50
|
1.041
|
48
|
30
|
75
|
9
|
1
|
3.8
|
1
|
F
|
D
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
45
|
55
|
1.145
|
48
|
36
|
95
|
8
|
1
|
5.2
|
0
|
F
|
D
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
17
|
69
|
1.210
|
57
|
27
|
55
|
3
|
1
|
3
|
0
|
F
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
48
|
65
|
1.140
|
57
|
34
|
90
|
11
|
1
|
5.3
|
1
|
F
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
28
|
75
|
1.119
|
67
|
44
|
95
|
9
|
1
|
4.4
|
1
|
F
|
F
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
43
|
77
|
1.149
|
67
|
42
|
95
|
20
|
1
|
5.5
|
1
|
F
|
F
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19
|
24
|
1.043
|
23
|
32
|
85
|
1
|
0
|
4.6
|
1
|
M
|
A
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
25
|
24
|
1.043
|
23
|
41
|
70
|
4
|
0
|
4
|
0
|
M
|
A
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
40
|
25
|
1.086
|
23
|
24
|
90
|
2
|
0
|
6.3
|
0
|
M
|
A
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2
|
27
|
0.870
|
31
|
52
|
80
|
7
|
0
|
3.9
|
0
|
M
|
B
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
32
|
28
|
0.903
|
31
|
25
|
95
|
4
|
0
|
5.6
|
0
|
M
|
B
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
34
|
28
|
0.903
|
31
|
26
|
80
|
2
|
0
|
4.9
|
1
|
M
|
B
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
16
|
47
|
1.175
|
40
|
44
|
90
|
4
|
0
|
5.7
|
0
|
M
|
C
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
27
|
40
|
1.000
|
40
|
35
|
80
|
7
|
0
|
3.9
|
1
|
M
|
C
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
41
|
43
|
1.075
|
40
|
25
|
80
|
5
|
0
|
4.3
|
0
|
M
|
C
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5
|
47
|
0.979
|
48
|
36
|
90
|
16
|
0
|
5.7
|
1
|
M
|
D
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
30
|
49
|
1.020
|
48
|
45
|
90
|
18
|
0
|
4.3
|
0
|
M
|
D
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
58
|
1.017
|
57
|
34
|
85
|
8
|
0
|
5.7
|
0
|
M
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4
|
66
|
1.157
|
57
|
42
|
100
|
16
|
0
|
5.5
|
1
|
M
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12
|
60
|
1.052
|
57
|
52
|
95
|
22
|
0
|
4.5
|
0
|
M
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
33
|
64
|
1.122
|
57
|
35
|
90
|
9
|
0
|
5.5
|
1
|
M
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
38
|
56
|
0.982
|
57
|
45
|
95
|
11
|
0
|
4.5
|
0
|
M
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
44
|
60
|
1.052
|
57
|
45
|
90
|
16
|
0
|
5.2
|
1
|
M
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
46
|
65
|
1.140
|
57
|
39
|
75
|
20
|
0
|
3.9
|
1
|
M
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
47
|
62
|
1.087
|
57
|
37
|
95
|
5
|
0
|
5.5
|
1
|
M
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
49
|
60
|
1.052
|
57
|
41
|
95
|
21
|
0
|
6.6
|
0
|
M
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
50
|
66
|
1.157
|
57
|
38
|
80
|
12
|
0
|
4.6
|
0
|
M
|
E
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6
|
76
|
1.134
|
67
|
36
|
70
|
12
|
0
|
4.5
|
1
|
M
|
F
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9
|
77
|
1.149
|
67
|
49
|
100
|
10
|
0
|
4
|
1
|
M
|
F
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
21
|
76
|
1.134
|
67
|
43
|
95
|
13
|
0
|
6.3
|
1
|
M
|
F
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
29
|
72
|
1.074
|
67
|
52
|
95
|
5
|
0
|
5.4
|
0
|
M
|
F
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
brin_j
data.docx
0
