1144 yes range does not contain 0 2191 yes range does

11.44 YES Range does not contain 0
21.91 YES Range does not contain 0
32.13 YES Range does not contain 0
42.29 YES Range does not contain 0
55.48 YES Range does not contain 0
26.87 YES Range does not contain 0
23.87 YES Range does not contain 0
34.15 YES Range does not contain 0
47.24 YES Range does not contain 0
Difference
Significant
?

14.04 YES Range does not contain 0
24.37 YES Range does not contain 0
37.43 YES Range does not contain 0
14.15 YES Range does not contain 0
27.21 YES Range does not contain 0
15.63 YES Range does not contain 0
1.1408451E-22 CHISQ.TEST(L62:Q63, L66:Q68)
Use Cell K54 for the Excel test outcome location.
Place the actual distribution in the table below.
A B C D
is <0.05 Male 7 5 3 2
Female 8 2 2 3
15 7 5 5
Place the expected distribution in the table below.
A B C D
Male 7.5 1.4 0.6 0.4
Female 7.5 0.56 0.4 0.6
qually across.
ctices are gender specific or related to education levels.
e not sufficient enough to provide any answers on the pay scale between men and women.
the alpha.
pattern across the salary grades?

Data Input Table:
Salary Ran
Group name: A B C
List salaries within each grade
23.3 26.5 41.6
24.3 34.8 40.6
22.6 35.5 45.5
23.7 35.7 42.6
23.7 28.3 41.2
24.4 27.3
22.9 37.2
24.9
23.8
22.7
23.3
23.5
22.8
23.6
23.1
P-value F crit
1.2202E-35 2.42704

E F
5 3 25
7 3 25
12 6 50
E F
1.2 0.36
1.68 0.36

nge Groups
Salary Grade Degree Grade
D E F 23.3 A 0 A
48.1 58.7 74 24.3 A 0 A
53.6 66.7 77.1 22.6 A 0 A
57.5 66.7 74.2 23.7 A 0 A
49.6 63.6 75.2 23.7 A 0 A
53.8 62.7 79.7 24.4 A 0 A
56 76.2 22.9 A 0 A
61.3 24.9 A 1 A
64.6 23.8 A 1 A
69.5 22.7 A 1 A
67 23.3 A 1 A
59.9 23.5 A 1 A
64.8 22.8 A 1 A
23.6 A 1 A
23.1 A 1 A
26.5 B 0 B
34.8 B 0 B
35.5 B 0 B
35.7 B 0 B
28.3 B 0 B
27.3 B 1 B
37.2 B 1 B
41.6 C 0 C
40.6 C 0 C
0 C
45.5 C 1 C
42.6 C 1 C
41.2 C 0 D
48.1 D 0 D
53.6 D 1 D
57.5 D 1 D
49.6 D 1 D
53.8 D 0 E
58.7 E 0 E
66.7 E 0 E
0 E
63.6 E 0 E
62.7 E 1 E
56 E 1 E
61.3 E 1 E
1 E

69.5 E 1 E
67 E 1 E
59.9 E 1 E
0 F
74 F 0 F
77.1 F 0 F
1 F
75.2 F 1 F
79.7 F 1 F
76.2 F

Week 4: Identifying relationships - correlations and regression
To Ensure full credit for each question, you need to show how you got your results. This in
or showing the excel formula in each cell. Be sure to copy the appropriate data
1 What is the correlation between and among the interval/ratio level variables with
a. Create the correlation table.
i. What is the data input ranged used for this question:
ii. Create a correlation table in cell K08.
b. Technically, we should perform a hypothesis testing on each correlation to dete
if it is significant or not. However, we can be faithful to the process and save som
time by finding the minimum correlation that would result in a two tail rejection o
We can then compare each correlation to this value, and those exceeding it (in eith
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 n