September 28, 2025 Claire B 0 Comments

Score:
<1 point>
<1 point>
<1 point>
<1 point>
<2 points>
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 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 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 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= BSBA 1 =
MS)
36 23 1 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.05 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.21 57 27 55 3 1 3 0 F E
48 65 1.14 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.87 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 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.02 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.14 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

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A

Order Solution Now

Categories: