chi square analysis

profilecccclll
DATA_ARE112_Sp2020_Analysis_ANOVA_Chi_Sq.xlsx
Home>Business & Finance homework help>Economics homework help>chi square analysis

Chi_Sq_DATA

Employee_Ref Promoted Management_Training_Program
1 No No
2 Yes Yes
3 No No
4 Yes Yes
5 No No
6 No No
7 Yes Yes
8 Yes Yes
9 Yes Yes
10 Yes Yes
11 No No
12 No No
13 Yes Yes
14 No No
15 Yes No
16 Yes Yes
17 No Yes
18 Yes Yes
19 Yes Yes
20 Yes Yes
21 Yes Yes
22 Yes Yes
23 No No
24 Yes Yes
25 No No
26 Yes Yes
27 No No
28 Yes Yes
29 Yes Yes
30 No No
31 No No
32 Yes Yes
33 Yes Yes
34 No No
35 Yes Yes
36 No No
37 Yes Yes
38 No No
39 Yes Yes
40 No No
41 No No
42 Yes Yes
43 Yes Yes
44 Yes Yes
45 Yes Yes
46 No No
47 No No
48 No No
49 Yes No
50 Yes Yes
51 Yes Yes
52 Yes Yes
53 Yes Yes
54 Yes Yes
55 No No
56 Yes Yes
57 No No
58 Yes Yes
59 No No
60 No No
61 Yes Yes
62 Yes Yes
63 Yes Yes
64 Yes Yes
65 No No
66 Yes Yes
67 No No
68 No No
69 No No
70 No No
71 No No
72 No No
73 Yes Yes
74 No Yes
75 No No
76 No No
77 No No
78 Yes Yes
79 No Yes
80 Yes Yes
81 Yes Yes
82 No Yes
83 No No
84 No No
85 No No
86 No No
87 No No
88 No No
89 No No
90 Yes Yes
91 No No
92 Yes Yes
93 No Yes
94 Yes Yes
95 Yes No
96 Yes Yes
97 Yes Yes
98 Yes Yes
99 No No
100 No No
101 No No
102 Yes Yes
103 Yes Yes
104 Yes Yes
105 Yes Yes
106 Yes Yes
107 Yes Yes
108 Yes Yes
109 No No
110 Yes Yes
111 No No
112 Yes Yes
113 No No
114 Yes Yes
115 Yes No
116 No No
117 Yes Yes
118 No No
119 No Yes
120 Yes Yes
121 No No
122 Yes Yes
123 Yes Yes
124 No No
125 Yes Yes
126 No No
127 Yes Yes
128 Yes Yes
129 Yes Yes
130 Yes Yes
131 Yes No
132 No No
133 Yes Yes
134 Yes Yes
135 No No
136 Yes Yes
137 Yes Yes
138 Yes Yes
139 No No
140 No No Here is where the "HIDE" command was used
141 No No
142 No No
143 No No
144 No No
145 Yes Yes
146 No No We are testing the idea that Promotion = function (Going to the training program).
147 Yes Yes
148 Yes Yes
149 No No
150 No Yes Chi square test with Excel formula
Formula =COUNTIF(B2:B151,$A$154)
# Promoted Training Program Formula =CHISQ.TEST(C154:C155,D154:D155)
Yes
No p-value =
Total
In Per Cent
# Promoted Training Program
Yes
No
Total

ANOVA_DATA

Item_# Week_Code Satisfaction_Level Office_Code Office
1 Week 2 38 1 Boston Week # Boston Atlanta Los Angeles Portland
2 Week 4 40 1 Boston 1 38 42 44 31
3 Week 6 30 1 Boston 2 40 45 43 43
4 Week 8 42 1 Boston 3 30 44 38 44
5 Week 10 36 1 Boston 4 42 43 40 43
6 Week 12 41 1 Boston 5 36 46 37 36
7 Week 14 40 1 Boston 6 41 42 35 43
8 Week 16 42 1 Boston 7 40 35 37 46
9 Week 18 36 1 Boston 8 42 43 35 45
10 Week 20 41 1 Boston 9 36 46 40 46
11 Week 22 40 1 Boston 10 41 43 37 36
12 Week 24 35 1 Boston 11 40 42 36 40
13 Week 26 34 1 Boston 12 35 45 39 41
14 Week 28 41 1 Boston 13 34 39 40 40
15 Week 30 39 1 Boston 14 41 39 36 39
16 Week 32 42 1 Boston 15 39 44 44 38
17 Week 2 42 2 Atlanta 16 42 43 39 42
18 Week 4 45 2 Atlanta Average 38.6 42.6 38.8 40.8
19 Week 6 44 2 Atlanta
20 Week 8 43 2 Atlanta
21 Week 10 46 2 Atlanta
22 Week 12 42 2 Atlanta
23 Week 14 35 2 Atlanta
24 Week 16 43 2 Atlanta
25 Week 18 46 2 Atlanta
26 Week 20 43 2 Atlanta
27 Week 22 42 2 Atlanta
28 Week 24 45 2 Atlanta
29 Week 26 39 2 Atlanta
30 Week 28 39 2 Atlanta
31 Week 30 44 2 Atlanta
32 Week 32 43 2 Atlanta
33 Week 2 44 3 Los Angeles
34 Week 4 43 3 Los Angeles
35 Week 6 38 3 Los Angeles
36 Week 8 40 3 Los Angeles
37 Week 10 37 3 Los Angeles
38 Week 12 35 3 Los Angeles
39 Week 14 37 3 Los Angeles
40 Week 16 35 3 Los Angeles
41 Week 18 40 3 Los Angeles
42 Week 20 37 3 Los Angeles
43 Week 22 36 3 Los Angeles
44 Week 24 39 3 Los Angeles
45 Week 26 40 3 Los Angeles
46 Week 28 36 3 Los Angeles
47 Week 30 44 3 Los Angeles
48 Week 32 39 3 Los Angeles
49 Week 2 31 4 Portland
50 Week 4 43 4 Portland
51 Week 6 44 4 Portland
52 Week 8 43 4 Portland
53 Week 10 36 4 Portland
54 Week 12 43 4 Portland
55 Week 14 46 4 Portland
56 Week 16 45 4 Portland
57 Week 18 46 4 Portland
58 Week 20 36 4 Portland
59 Week 22 40 4 Portland
60 Week 24 41 4 Portland
61 Week 26 40 4 Portland
62 Week 28 39 4 Portland
63 Week 30 38 4 Portland
64 Week 32 42 4 Portland
40.2
40