Ashford 4 week three 1

Ashford 4: - Week 3 - Assignment

Problem Set Week Three

Complete the problems included in the resources below and submit your work in an Excel document. Be sure to show all of your work and clearly label all calculations.

All statistical calculations will use the Employee Salary Data Set and the Week 3 assignment sheet.
Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment.
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