Ask a Question

Ashford BUS 308 Week 4 Problem Set (2017)

Regular price $15.00

ID

Salary

Compa-ratio

Midpoint

Age

Performance Rating

Service

Gender

Raise

Degree

Gender1

Grade

Copy Employee Data set to this page.

1

57,7

1,013

57

34

85

8

0

5,7

0

M

E

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)?

2

27,3

0,880

31

52

80

7

0

3,9

0

M

B

Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work.

3

35,5

1,146

31

30

75

5

1

3,6

1

F

B

4

60,9

1,068

57

42

100

16

0

5,5

1

M

E

The column labels in the table mean:

5

47

0,979

48

36

90

16

0

5,7

1

M

D

ID – Employee sample number

Salary – Salary in thousands

6

72,8

1,086

67

36

70

12

0

4,5

1

M

F

Age – Age in years

Performance Rating – Appraisal rating (Employee evaluation score)

7

41,8

1,046

40

32

100

8

1

5,7

1

F

C

SERvice – Years of service

Gender: 0 = male, 1 = female

8

21,8

0,947

23

32

90

9

1

5,8

1

F

A

Midpoint – salary grade midpoint

Raise – percent of last raise

9

76,3

1,139

67

49

100

10

0

4

1

M

F

Grade – job/pay grade

Degree (0= BSBA 1 = MS)

10

22,5

0,978

23

30

80

7

1

4,7

1

F

A

Gender1 (Male or Female)

Compa-ratio - salary divided by midpoint

11

22,8

0,991

23

41

100

19

1

4,8

1

F

A

12

64,5

1,132

57

52

95

22

0

4,5

0

M

E

13

41,4

1,035

40

30

100

2

1

4,7

0

F

C

14

23,1

1,003

23

32

90

12

1

6

1

F

A

15

23,5

1,021

23

32

80

8

1

4,9

1

F

A

16

47,9

1,198

40

44

90

4

0

5,7

0

M

C

17

67

1,175

57

27

55

3

1

3

1

F

E

18

35,2

1,134

31

31

80

11

1

5,6

0

F

B

19

24,3

1,058

23

32

85

1

0

4,6

1

M

A

20

33,6

1,085

31

44

70

16

1

4,8

0

F

B

21

77,5

1,156

67

43

95

13

0

6,3

1

M

F

22

53,6

1,116

48

48

65

6

1

3,8

1

F

D

23

22,9

0,996

23

36

65

6

1

3,3

0

F

A

24

61,2

1,276

48

30

75

9

1

3,8

0

F

D

25

24,5

1,066

23

41

70

4

0

4

0

M

A

26

22,3

0,970

23

22

95

2

1

6,2

0

F

A

27

38,4

0,961

40

35

80

7

0

3,9

1

M

C

28

75,3

1,124

67

44

95

9

1

4,4

0

F

F

29

73,2

1,092

67

52

95

5

0

5,4

0

M

F

30

49,5

1,031

48

45

90

18

0

4,3

0

M

D

31

23,9

1,040

23

29

60

4

1

3,9

1

F

A

32

27,2

0,877

31

25

95

4

0

5,6

0

M

B

33

61,8

1,084

57

35

90

9

0

5,5

1

M

E

34

28,1

0,905

31

26

80

2

0

4,9

1

M

B

35

24,5

1,066

23

23

90

4

1

5,3

0

F

A

36

23

0,998

23

27

75

3

1

4,3

0

F

A

37

23,6

1,026

23

22

95

2

1

6,2

0

F

A

38

59,7

1,047

57

45

95

11

0

4,5

0

M

E

39

34,4

1,111

31

27

90

6

1

5,5

0

F

B

40

23,9

1,040

23

24

90

2

0

6,3

0

M

A

41

40,6

1,016

40

25

80

5

0

4,3

0

M

C

42

23,3

1,011

23

32

100

8

1

5,7

1

F

A

43

77,3

1,154

67

42

95

20

1

5,5

0

F

F

44

62,3

1,093

57

45

90

16

0

5,2

1

M

E

45

58

1,209

48

36

95

8

1

5,2

1

F

D

46

61,5

1,079

57

39

75

20

0

3,9

1

M

E

47

61,2

1,074

57

37

95

5

0

5,5

1

M

E

48

64,6

1,133

57

34

90

11

1

5,3

1

F

E

49

62,5

1,096

57

41

95

21

0

6,6

0

M

E

50

63,9

1,121

57

38

80

12

0

4,6

0

M

E

Questions & Answers

Have a Question?

Be the first to ask a question about this.

Ask a Question