1What is the correlation between and among the interval/ratio level variables with salary?(Do not include compa-ratio in this question.)

a. Create the correlation table.

b. Technically, we should perform a hypothesis testing on each correlation to determine

if it is significant or not.However, we can be faithful to the process and save some

time by finding the minimum correlation that would result in a two tail rejection of the null.

We can then compare each correlation to this value, and those exceeding it (in either a

positive or negative direction) can be considered statistically significant.

i. What is the t-value we would use to cut off the two tails?

ii. What is the associated correlation value related to this t-value?r =

c. What variable(s) is(are) significantly correlated to salary?

d. Are there any surprises - correlations you though would be significant and are not, or non significant correlations you thought would be?

e. Why does or does not this information help answer our equal pay question?

ID Salary Compa-ratio Midpoint Age Performance Rating Service Gender Raise Degree Gender1 Grade

1 57.7 1.012 57 34 85 8 0 5.7 0 M E

2 27.9 0.899 31 52 80 7 0 3.9 0 M B

3 36.2 1.168 31 30 75 5 1 3.6 1 F B

4 63.7 1.117 57 42 100 16 0 5.5 1 M E

5 45.5 0.947 48 36 90 16 0 5.7 1 M D

6 74.4 1.110 67 36 70 12 0 4.5 1 M F

7 42.1 1.052 40 32 100 8 1 5.7 1 F C

8 22.8 0.992 23 32 90 9 1 5.8 1 F A

9 77.7 1.159 67 49 100 10 0 4 1 M F

10 23 0.998 23 30 80 7 1 4.7 1 F A

11 21.8 0.949 23 41 100 19 1 4.8 1 F A

12 55.5 0.973 57 52 95 22 0 4.5 0 M E

13 40.5 1.012 40 30 100 2 1 4.7 0 F C

14 23.6 1.028 23 32 90 12 1 6 1 F A

15 23.4 1.016 23 32 80 8 1 4.9 1 F A

16 42.3 1.058 40 44 90 4 0 5.7 0 M C

17 67.5 1.184 57 27 55 3 1 3 1 F E

18 34.1 1.101 31 31 80 11 1 5.6 0 F B

19 24.3 1.056 23 32 85 1 0 4.6 1 M A

20 35.2 1.135 31 44 70 16 1 4.8 0 F B

21 79.1 1.181 67 43 95 13 0 6.3 1 M F

22 51.1 1.065 48 48 65 6 1 3.8 1 F D

23 25.3 1.101 23 36 65 6 1 3.3 0 F A

24 51 1.063 48 30 75 9 1 3.8 0 F D

25 23 1.000 23 41 70 4 0 4 0 M A

26 24.4 1.060 23 22 95 2 1 6.2 0 F A

27 42.9 1.073 40 35 80 7 0 3.9 1 M C

28 77.2 1.152 67 44 95 9 1 4.4 0 F F

29 77.5 1.157 67 52 95 5 0 5.4 0 M F

30 46.2 0.963 48 45 90 18 0 4.3 0 M D

31 22.7 0.985 23 29 60 4 1 3.9 1 F A

32 27.2 0.876 31 25 95 4 0 5.6 0 M B

33 62.9 1.104 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 23.9 1.038 23 23 90 4 1 5.3 0 F A

36 22.8 0.993 23 27 75 3 1 4.3 0 F A

37 22.6 0.984 23 22 95 2 1 6.2 0 F A

38 60 1.052 57 45 95 11 0 4.5 0 M E

39 33.5 1.081 31 27 90 6 1 5.5 0 F B

40 23 1.002 23 24 90 2 0 6.3 0 M A

41 42.1 1.052 40 25 80 5 0 4.3 0 M C

42 24.1 1.049 23 32 100 8 1 5.7 1 F A

43 74.5 1.112 67 42 95 20 1 5.5 0 F F

44 63.8 1.120 57 45 90 16 0 5.2 1 M E

45 48.9 1.018 48 36 95 8 1 5.2 1 F D

46 61.8 1.085 57 39 75 20 0 3.9 1 M E

47 61.5 1.079 57 37 95 5 0 5.5 1 M E

48 65.6 1.150 57 34 90 11 1 5.3 1 F E

49 54.9 0.963 57 41 95 21 0 6.6 0 M E

50 61.9 1.086 57 38 80 12 0 4.6 0 M E