Analysis

darren04
DATA_Analysis.xlsx
Home>Business & Finance homework help>Operations Management homework help>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 Yes No
47 Yes 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 Yes 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 No
120 Yes Yes
121 No No
122 Yes No
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 =CHISQ.TEST(actual_range, expected_range)
149 No No
150 No Yes Chi square test with Excel formula
Formula =COUNTIF(c2:c151,$B$153)
# Promoted Training Program Formula =CHISQ.TEST(C154:C155,D154:D155)
Yes 83
No 67 p-value =
Total 150 0
In Per Cent
# Promoted Training Program
Yes 55.3%
No 44.7%
Total 100%

ARE112 - Winter 2021 #A Analysis Project - Chi Square

ANOVA_DATA

Item # Week Code Satisfaction Level Office Code Office
1 Week1 38 1 Boston Week # Boston Atlanta San Diego Seattle
2 Week2 40 1 Boston 1 38 42 44 31
3 Week3 30 1 Boston 2 40 45 43 43
4 Week4 42 1 Boston 3 30 44 40 44
5 Week5 36 1 Boston 4 42 43 40 43
6 Week6 41 1 Boston 5 36 46 37 36
7 Week7 40 1 Boston 6 41 42 35 43
8 Week8 42 1 Boston 7 40 37 37 46
9 Week9 36 1 Boston 8 42 43 35 45
10 Week10 41 1 Boston 9 36 46 39 46
11 Week11 40 1 Boston 10 41 43 37 36
12 Week12 35 1 Boston 11 40 42 36 38
13 Week13 34 1 Boston 12 35 45 39 39
14 Week14 41 1 Boston 13 34 39 40 40
15 Week15 39 1 Boston 14 41 39 36 39
16 Week16 42 1 Boston 15 39 44 44 38
17 Week1 42 2 Atlanta 16 42 43 39 40
18 Week2 45 2 Atlanta Average 38.6 42.7 38.8 40.4
19 Week3 44 2 Atlanta
20 Week4 43 2 Atlanta Hide Command
21 Week5 46 2 Atlanta
22 Week6 42 2 Atlanta
23 Week7 37 2 Atlanta
24 Week8 43 2 Atlanta
25 Week9 46 2 Atlanta
26 Week10 43 2 Atlanta
27 Week11 42 2 Atlanta
28 Week12 45 2 Atlanta
29 Week13 39 2 Atlanta
30 Week14 39 2 Atlanta
31 Week15 44 2 Atlanta
32 Week16 43 2 Atlanta
33 Week1 44 3 San Diego
34 Week2 43 3 San Diego
35 Week3 40 3 San Diego
36 Week4 40 3 San Diego
37 Week5 37 3 San Diego
38 Week6 35 3 San Diego
39 Week7 37 3 San Diego
40 Week8 35 3 San Diego
41 Week9 39 3 San Diego
42 Week10 37 3 San Diego
43 Week11 36 3 San Diego
44 Week12 39 3 San Diego
45 Week13 40 3 San Diego
46 Week14 36 3 San Diego
47 Week15 44 3 San Diego
48 Week16 39 3 San Diego
49 Week1 31 4 Seattle
50 Week2 43 4 Seattle
51 Week3 44 4 Seattle
52 Week4 43 4 Seattle
53 Week5 36 4 Seattle
54 Week6 43 4 Seattle
55 Week7 46 4 Seattle
56 Week8 45 4 Seattle
57 Week9 46 4 Seattle
58 Week10 36 4 Seattle
59 Week11 38 4 Seattle
60 Week12 39 4 Seattle
61 Week13 40 4 Seattle
62 Week14 39 4 Seattle
63 Week15 38 4 Seattle
64 Week16 40 4 Seattle
Average 40.1
Median 40

ARE 112 Winter 2021 #A Analysis Project - ANOVA