BUS 308 Statistics for Managers Week 2 Assignment
nickykabondv
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 | 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.210 | 57 | 27 | 55 | 3 | 1 | 3 | 0 | F | E | |||||
48 | 65 | 1.140 | 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.870 | 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.000 | 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.020 | 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.140 | 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 | |||||
- 9 years ago
- 20
Purchase the answer to view it
- bus_308_week_2_assignment_answer_file.xlsx
Purchase the answer to view it
- bus_308_week_two_problem_set.xlsx
- (businees law) answer the 2 quastions in an essay way indiviually National Trucking Corporation (NTC) files a suit in a state court...
- Apply the knowledge you have learned about the primary role of media in correlation to the theorist goal, and how terrorists use the media as a weapon.
- BIS 303 Week 2 Assignment 1 Hospitality Information Systems Direct Reservations
- AED 201 Week 2 CheckPoint Managing a Daily Teaching Schedule part 2
- Hi, I am looking for someone who will wirte my paper about IBM's "Watson" Programme and how it could be implemented...
- Analysis paper
- can anyone help me?
- Lab report
- Examine and discuss the characteristics of NPV and the role that this method plays in capital investment decision making. In addition, discuss the advantages of using this method instead of the other evaluation methods examined this week.
- project report