BUS 308 Statistics for Managers Week 2 Assignment

profilenickykabondv

 

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
    Answer(2)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      bus_308_week_2_assignment_answer_file.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      bus_308_week_two_problem_set.xlsx
    Bids(0)
    other Questions(10)