BUS 308 Statistics for Managers Week 2 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= BSBA 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<

© Copyright 2020 Topnursingessay