ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
Sal
34
41
23
22
23
42
24
24
69
36
34
57
23
50
24
75
24
24
23
22
35
24
77
55
65
58
27
66
47
76
77
60
47
24
76
24
40
72
49
28
64
Compa
1,096
1,025
1,000
0,956
1,000
1,050
1,043
1,043
1,210
1,161
1,096
1,187
1,000
1,041
1,043
1,119
1,043
1,043
1,000
0,956
1,129
1,043
1,149
1,145
1,140
1,017
0,870
1,157
0,979
1,134
1,149
1,052
1,175
1,043
1,134
1,043
1,000
1,074
1,020
0,903
1,122
Mid
31
40
23
23
23
40
23
23
57
31
31
48
23
48
23
67
23
23
23
23
31
23
67
48
57
57
31
57
48
67
67
57
40
23
67
23
40
67
48
31
57
Age
30
32
32
30
41
30
32
32
27
31
44
48
36
30
22
44
29
23
27
22
27
32
42
36
34
34
52
42
36
36
49
52
44
32
43
41
35
52
45
25
35
EES
75
100
90
80
100
100
90
80
55
80
70
65
65
75
95
95
60
90
75
95
90
100
95
95
90
85
80
100
90
70
100
95
90
85
95
70
80
95
90
95
90
SR
5
8
9
7
19
2
12
8
3
11
16
6
6
9
2
9
4
4
3
2
6
8
20
8
11
8
7
16
16
12
10
22
4
1
13
4
7
5
18
4
9
G
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Raise
3,6
5,7
5,8
4,7
4,8
4,7
6
4,9
3
5,6
4,8
3,8
3,3
3,8
6,2
4,4
3,9
5,3
4,3
6,2
5,5
5,7
5,5
5,2
5,3
5,7
3,9
5,5
5,7
4,5
4
4,5
5,7
4,6
6,3
4
3,9
5,4
4,3
5,6
5,5
Deg
1
1
1
1
1
0
1
1
1
0
0
1
0
0
0
0
1
0
0
0
0
1
0
1
1
0
0
1
1
1
1
0
0
1
1
0
1
0
0
0
1
Gen1
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
Gr
B
C
A
A
A
C
A
A
E
B
B
D
A
D
A
F
A
A
A
A
B
A
F
D
E
E
B
E
D
F
F
E
C
A
F
A
C
F
D
B
E
42
43
44
45
46
47
48
49
50
28
56
25
43
60
65
62
60
66
0,903
0,982
1,086
1,075
1,052
1,140
1,087
1,052
1,157
31
57
23
40
57
57
57
57
57
26
45
24
25
45
39
37
41
38
80
95
90
80
90
75
95
95
80
2
11
2
5
16
20
5
21
12
0
0
0
0
0
0
0
0
0
4,9
4,5
6,3
4,3
5,2
3,9
5,5
6,6
4,6
1
0
0
0
1
1
1
0
0
M
M
M
M
M
M
M
M
M
B
E
A
C
E
E
E
E
E
The ongoing question that the weekly assignments will focus on is: Are males and females paid the same for equa
Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work.
The column labels in the table mean:
ID – Employee sample number Sal – Salary in thousands
Age – Age in years
EES – Appraisal rating (Employee evaluation score)
SER – Years of service
G – Gender (0 = male, 1 = female)
Mid – salary grade midpoint
Raise – percent of last raise
Grade – job/pay grade
Deg (0= BS\BA 1 = MS)
Gen1 (Male or Female)
Compa - salary divided by midpoint, a measure of salary that removes th
This data should be treated as a sample of employees taken from a company that has about 1,000
employees using a random sampling approach.
Mac Users: The homework in this course assumes students have Windows Excel, and
can load the Analysis ToolPak into their version of Excel.
The analysis tool pak has been removed from Excel for Windows, but a free third-party
tool that can be used (found on an answers Microsoft site) is:
http://www.analystsoft.com/en/products/statplusmacle
Like the Microsoft site, I make cannot guarantee the program, but do know that
Statplus is a respected statistical package. You may use other approaches or tools
as desired to complete the assignments.
nd females paid the same for equal work (under the Equal Pay Act)?
Week 1. Describing the data.
rate and show the descriptive statistics for each appropriate variable in the sample data set.
ectly for? Why?
SR
G
8,96
0,809
8
8
5,718
32,692
-0,399
0,728
21
1
22
448
50
Raise
0,5
0,071
0,5
0
0,505
0,255
-2,085
0,000
1
0
1
25
50
4,938
0,123
4,9
5,7
0,867
0,752
-0,794
-0,164
3,6
3
6,6
246,9
50
Deg
0,5
0,071
0,5
0
0,505
0,255
-2,085
0,000
1
0
1
25
50
ill not work on non numerical numbers, so the Gen 1 and grade columns will not work.
ndard deviation
unctions (average and stdev).
cond one only counts males.
es: .337,-1.406,.788,
-0.281,1.350,1.406,.450,-0.281,-1.575,1.350,-1.575,-0.675,1.125,-0.169,-1.350,0.675,
-1.350,0.225,-1.519,-0.5
Week 2
Testing means with the t-test
Purchase answer to see full
attachment