(solution) I am working on Statistics and we are on week three. I have

(solution) I am working on Statistics and we are on week three. I have

I am working on Statistics and we are on week three. I have uploaded the data sheet and the worksheet. Let me know if you need something else 

Dj

ID Salary Compa Midpoint Age 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 60.8
26.1
35.4
61.3
46.8
74
41.8
22.5
82.5
23
24.1
65.1
42
23.9
23.7
35.7
71
34.4
24.9
34.2
76.8
62.1
22.7
49.4
24.5
23.2
46.9
77.3
77.7
46.7
23.1
29
63.8
28.1
23.4
23.3
23.5
59.3 1.066 57
31
31
57
48
67
40
23
67
23
23
57
40
23
23
40
57
31
23
31
67
48
23
48
23
23
40
67
67
48
23
31
57
31
23
23
23
57 34
52
30
42
36
36
32
32
49
30
41
52
30
32
32
44
27
31
32
44
43
48
36
30
41
22
35
44
52
45
29
25
35
26
23
27
22
45 0.843
1.142
1.076
0.974
1.104
1.046
0.977
1.231
1.002
1.049
1.142
1.051
1.041
1.030
0.892
1.246
1.110
1.084
1.104
1.147
1.294
0.988
1.029
1.066
1.008
1.173
1.153
1.160
0.973
1.005
0.935
1.119
0.907
1.019
1.014
1.023
1.040 Performance Service Gender Raise
Rating
85
80
75
100
90
70
100
90
100
80
100
95
100
90
80
90
55
80
85
70
95
65
65
75
70
95
80
95
95
90
60
95
90
80
90
75
95
95 8
7
5
16
16
12
8
9
10
7
19
22
2
12
8
4
3
11
1
16
13
6
6
9
4
2
7
9
5
18
4
4
9
2
4
3
2
11 0
0
1
0
0
0
1
1
0
1
1
0
1
1
1
0
1
1
0
1
0
1
1
1
0
1
0
1
0
0
1
0
0
0
1
1
1
0 5.7
3.9
3.6
5.5
5.7
4.5
5.7
5.8
4
4.7
4.8
4.5
4.7
6
4.9
5.7
3
5.6
4.6
4.8
6.3
3.8
3.3
3.8
4
6.2
3.9
4.4
5.4
4.3
3.9
5.6
5.5
4.9
5.3
4.3
6.2
4.5 39
40
41
42
43
44
45
46
47
48
49
50 35.6
24.5
50.1
22.6
73.9
60.6
53.3
64.7
63.3
69.1
58.4
62.6 1.148
1.067
1.253
0.983
1.103
1.063
1.110
1.135
1.111
1.213
1.025
1.099 31
23
40
23
67
57
48
57
57
57
57
57 27
24
25
32
42
45
36
39
37
34
41
38 90
90
80
100
95
90
95
75
95
90
95
80 6
2
5
8
20
16
8
20
5
11
21
12 1
0
0
1
1
0
1
0
0
1
0
0 5.5
6.3
4.3
5.7
5.5
5.2
5.2
3.9
5.5
5.3
6.6
4.6 Degree Gender
1
0
0
1
1
1
1
1
1
1
1
1
0
0
1
1
0
1
0
1
0
1
1
0
0
0
0
1
0
0
0
1
0
1
1
0
0
0
0 M
M
F
M
M
M
F
F
M
F
F
M
F
F
F
M
F
F
M
F
M
F
F
F
M
F
M
F
M
M
F
M
M
M
F
F
F
M Gr
E
B
B
E
D
F
C
A
F
A
A
E
C
A
A
C
E
B
A
B
F
D
A
D
A
A
C
F
F
D
A
B
E
B
A
A
A
E The ongoing question that the weekly assignments will focus on is: Are males and fema Note: to simplfy the analysis, we will assume that jobs within each grade comprise equa The column labels in the table mean:
ID ? Employee sample number
Salary ? Salary in thousands
Age ? Age in years
Performance Rating – Appraisal rating (emp
Service ? Years of service (rounded) Gender ? 0 = male, 1 = female
Midpoint ? salary grade midpoint
Raise ? percent of last raise
Grade ? job/pay grade
Degree (0= BSBA 1 = MS)
Gender1 (Male or Female)
Compa – salary divided by midpoint 0
0
0
1
0
1
1
1
1
1
0
0 F
M
M
F
F
M
F
M
M
F
M
M B
A
C
A
F
E
D
E
E
E
E
E on is: Are males and females paid the same for equal work (under the Equal Pay Act)? each grade comprise equal work. thousands
g – Appraisal rating (employee evaluation score)
, 1 = female vided by midpoint Sal Compa
24 1.045 24.2 1.053 23.4 1.018 23.4 1.017 22.6 0.983 22.9 0.995 23.1 1.003 23.3 1.011 22.7 0.985 23.5 1.023 23 1.002 24 1.042 35.5 1.145 34.7 1.119 35.5 1.146 35.2 1.136 40.4 1.01 42.7 1.068 53.4 1.112 51.5 1.072 49.8 1.037 68.3 1.198 65.4 1.148 78.4 1.17 75.9 1.133 24 1.044 23.3 1.012 24.1 1.049 27.5 0.887 27.1 0.875 27.7 0.895 40.8 1.019 43.9 1.097 41 1.025 48.7 1.014 49.4 1.029 64.4 1.13 64.5 1.132 58.9 1.033 57.9 1.016 59 1.035 63.3 1.111 56.8 0.996 58 1.017 62.4 1.094 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
0
0
0
0 Mid
23
23
23
23
23
23
23
23
23
23
23
23
31
31
31
31
40
40
48
48
48
57
57
67
67
23
23
23
31
31
31
40
40
40
48
48
57
57
57
57
57
57
57
57
57 Age
32
30
41
32
32
36
22
29
23
27
22
32
30
31
44
27
32
30
48
30
36
27
34
44
42
32
41
24
52
25
26
44
35
25
36
45
34
42
52
35
45
45
39
37
41 EES
90
80
100
90
80
65
95
60
90
75
95
100
75
80
70
90
100
100
65
75
95
55
90
95
95
85
70
90
80
95
80
90
80
80
90
90
85
100
95
90
95
90
75
95
95 SR
9
7
19
12
8
6
2
4
4
3
2
8
5
11
16
6
8
2
6
9
8
3
11
9
20
1
4
2
7
4
2
4
7
5
16
18
8
16
22
9
11
16
20
5
21 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
0
0
0
0 Raise
5.8
4.7
4.8
6
4.9
3.3
6.2
3.9
5.3
4.3
6.2
5.7
3.6
5.6
4.8
5.5
5.7
4.7
3.8
3.8
5.2
3
5.3
4.4
5.5
4.6
4
6.3
3.9
5.6
4.9
5.7
3.9
4.3
5.7
4.3
5.7
5.5
4.5
5.5
4.5
5.2
3.9
5.5
6.6 Deg
1
1
1
1
1
0
0
1
0
0
0
1
1
0
0
0
1
0
1
0
1
1
1
0
0
1
0
0
0
0
1
0
1
0
1
0
0
1
0
1
0
1
1
1
0 63.8 1.12 79 1.179 77 1.149 74.8 1.116 76 1.135 0
0
0
0
0 57
67
67
67
67 38
36
49
43
52 80
70
100
95
95 12
12
10
13
5 0
0
0
0
0 4.6
4.5
4
6.3
5.4 0
1
1
1
0 SUMMARY OUTPUT
Regression Statistics
Multiple R 0.705018
R Square 0.49705 Adjusted R 0.413225
Standard E 0.056125
Observatio 50 ANOVA
df
Regression SS
7 MS Significance F 0.13075 0.018679 5.929623 7.83E-005 Residual 42 0.132302 Total 49 0.263052 0.00315 Coefficients
Standard Error t Stat
Intercept F P-value Lower 95%Upper 95%
Lower 95.0%
Upper 95.0% 0.948624 0.081717 11.60868 1.09E-014 0.783713 1.113535 0.783713 1.113535 Mid 0.0035 0.000649 5.390013 2.98E-006 0.002189 0.00481 0.002189 0.00481 Age 0.000553 0.001446 0.382293 0.704172 -0.002365 0.003471 -0.002365 0.003471 EES -0.001846 0.001025 -1.800846 0.078911 -0.003915 0.000223 -0.003915 0.000223 SR -0.000418 0.001828 -0.228814 0.820124 -0.004107 0.00327 -0.004107 0.00327 G 0.064665 0.01834 3.525963 0.001035 0.027654 0.101676 0.027654 0.101676 Raise 0.014655 0.013909 1.053639 0.298072 -0.013414 0.042724 -0.013414 0.042724 Deg 0.001468 0.01611 0.0911 0.927847 -0.031043 0.033979 -0.031043 0.033979 t-Test: Two-Sample Assuming Equal Variances
Variable 1 Variable 2
Mean
Variance
Observatio 1.06684 0.004302 0.006481
25 Pooled Var 0.005391
Hypothesiz
df
t Stat 1.04836 0
48
0.889835 P(T<=t) one0.188996
t Critical on 1.677224
P(T<=t) two0.377993
t Critical tw 2.010635 25 SUMMARY OUTPUT
Regression Statistics
Multiple R 0.993129
R Square 0.986305 Adjusted R 0.984022
Standard E 2.435282
Observatio 50 ANOVA
df
Regression SS
42 249.0852 Total 49 18187.51 Significance F 5.9306 Coefficients
Standard Error t Stat
Intercept F 7 17938.42 2562.632 432.1034 5.30E-037 Residual Upper 95.0% MS -4.871454 3.545701 -1.373905 P-value Lower 95%Upper 95%
Lower 95.0%
Upper 95.0%
0.17676 -12.02697 2.284059 -12.02697 2.284059 Mid 1.228416 0.028171 43.60516 1.32E-036 1.171563 1.285268 1.171563 1.285268 Age 0.036828 0.06274 0.586996 0.560349 -0.089786 0.163442 -0.089786 0.163442 EES -0.082158 0.044484 -1.846901 0.071815 -0.171931 0.007615 -0.171931 0.007615 SR -0.077848 0.079309 -0.981585 0.331925 -0.2379 0.082203 -0.2379 0.082203 G 2.914508 0.795761 3.662545 0.000694 1.308599 4.520418 1.308599 4.520418 Raise 0.676329 0.603509 1.120662 0.268799 -0.541601 1.894259 -0.541601 1.894259 Deg 0.034504 0.699007 0.049362 0.960865 -1.376149 1.445158 -1.376149 1.445158 Upper 95.0%