ID
Salary
Compa-ratio
Midpoint
Age
Performance Rating
Service
Gender
Raise
Degree
Gender1
Grade
Copy Employee Data set to this page.
1
57,7
1,013
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,3
0,880
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
35,5
1,146
31
30
75
5
1
3,6
1
F
B
4
60,9
1,068
57
42
100
16
0
5,5
1
M
E
The column labels in the table mean:
5
47
0,979
48
36
90
16
0
5,7
1
M
D
ID – Employee sample number
Salary – Salary in thousands
6
72,8
1,086
67
36
70
12
0
4,5
1
M
F
Age – Age in years
Performance Rating – Appraisal rating (Employee evaluation score)
7
41,8
1,046
40
32
100
8
1
5,7
1
F
C
SERvice – Years of service
Gender: 0 = male, 1 = female
8
21,8
0,947
23
32
90
9
1
5,8
1
F
A
Midpoint – salary grade midpoint
Raise – percent of last raise
9
76,3
1,139
67
49
100
10
0
4
1
M
F
Grade – job/pay grade
Degree (0= BSBA 1 = MS)
10
22,5
0,978
23
30
80
7
1
4,7
1
F
A
Gender1 (Male or Female)
Compa-ratio - salary divided by midpoint
11
22,8
0,991
23
41
100
19
1
4,8
1
F
A
12
64,5
1,132
57
52
95
22
0
4,5
0
M
E
13
41,4
1,035
40
30
100
2
1
4,7
0
F
C
14
23,1
1,003
23
32
90
12
1
6
1
F
A
15
23,5
1,021
23
32
80
8
1
4,9
1
F
A
16
47,9
1,198
40
44
90
4
0
5,7
0
M
C
17
67
1,175
57
27
55
3
1
3
1
F
E
18
35,2
1,134
31
31
80
11
1
5,6
0
F
B
19
24,3
1,058
23
32
85
1
0
4,6
1
M
A
20
33,6
1,085
31
44
70
16
1
4,8
0
F
B
21
77,5
1,156
67
43
95
13
0
6,3
1
M
F
22
53,6
1,116
48
48
65
6
1
3,8
1
F
D
23
22,9
0,996
23
36
65
6
1
3,3
0
F
A
24
61,2
1,276
48
30
75
9
1
3,8
0
F
D
25
24,5
1,066
23
41
70
4
0
4
0
M
A
26
22,3
0,970
23
22
95
2
1
6,2
0
F
A
27
38,4
0,961
40
35
80
7
0
3,9
1
M
C
28
75,3
1,124
67
44
95
9
1
4,4
0
F
F
29
73,2
1,092
67
52
95
5
0
5,4
0
M
F
30
49,5
1,031
48
45
90
18
0
4,3
0
M
D
31
23,9
1,040
23
29
60
4
1
3,9
1
F
A
32
27,2
0,877
31
25
95
4
0
5,6
0
M
B
33
61,8
1,084
57
35
90
9
0
5,5
1
M
E
34
28,1
0,905
31
26
80
2
0
4,9
1
M
B
35
24,5
1,066
23
23
90
4
1
5,3
0
F
A
36
23
0,998
23
27
75
3
1
4,3
0
F
A
37
23,6
1,026
23
22
95
2
1
6,2
0
F
A
38
59,7
1,047
57
45
95
11
0
4,5
0
M
E
39
34,4
1,111
31
27
90
6
1
5,5
0
F
B
40
23,9
1,040
23
24
90
2
0
6,3
0
M
A
41
40,6
1,016
40
25
80
5
0
4,3
0
M
C
42
23,3
1,011
23
32
100
8
1
5,7
1
F
A
43
77,3
1,154
67
42
95
20
1
5,5
0
F
F
44
62,3
1,093
57
45
90
16
0
5,2
1
M
E
45
58
1,209
48
36
95
8
1
5,2
1
F
D
46
61,5
1,079
57
39
75
20
0
3,9
1
M
E
47
61,2
1,074
57
37
95
5
0
5,5
1
M
E
48
64,6
1,133
57
34
90
11
1
5,3
1
F
E
49
62,5
1,096
57
41
95
21
0
6,6
0
M
E
50
63,9
1,121
57
38
80
12
0
4,6
0
M
E
Questions & Answers
Have a Question?
Be the first to ask a question about this.