Week 3 Excel Problems

Data

Computer Repair Times
Sample	Repair Time (Days)
1	18
2	15
3	17
4	9
5	37
6	15
7	8
8	29
9	10
10	14
11	17
12	12
13	13
14	12
15	11
16	14
17	13
18	16
19	13
20	15
21	16
22	12
23	34
24	29
25	13
26	19
27	12
28	15
29	16
30	14
31	15
32	7
33	40
34	16
35	11
36	11
37	10
38	13
39	14
40	9
41	18
42	8
43	13
44	8
45	10
46	13
47	16
48	9
49	9
50	12
51	16
52	9
53	15
54	17
55	38
56	11
57	15
58	16
59	10
60	9
61	25
62	15
63	7
64	11
65	19
66	13
67	12
68	20
69	12
70	13
71	11
72	8
73	14
74	10
75	12
76	15
77	17
78	10
79	13
80	18
81	26
82	14
83	15
84	12
85	15
86	9
87	10
88	21
89	11
90	36
91	8
92	20
93	14
94	18
95	19
96	14
97	12
98	16
99	17
100	12
101	10
102	10
103	15
104	23
105	13
106	19
107	19
108	12
109	13
110	12
111	16
112	12
113	14
114	11
115	14
116	7
117	16
118	12
119	16
120	10
121	12
122	36
123	9
124	9
125	22
126	16
127	12
128	17
129	9
130	25
131	14
132	13
133	13
134	8
135	14
136	8
137	17
138	13
139	12
140	8
141	12
142	17
143	22
144	19
145	10
146	19
147	10
148	17
149	13
150	9
151	13
152	9
153	11
154	12
155	17
156	15
157	15
158	27
159	17
160	10
161	20
162	15
163	12
164	15
165	23
166	17
167	8
168	17
169	10
170	20
171	16
172	12
173	11
174	22
175	11
176	14
177	17
178	18
179	11
180	21
181	15
182	14
183	16
184	10
185	19
186	14
187	20
188	27
189	20
190	15
191	20
192	11
193	14
194	13
195	26
196	9
197	8
198	15
199	16
200	21
201	14
202	15
203	15
204	14
205	15
206	15
207	16
208	5
209	11
210	14
211	8
212	21
213	10
214	18
215	13
216	16
217	11
218	11
219	10
220	18
221	11
222	18
223	23
224	22
225	19
226	9
227	11
228	10
229	6
230	39
231	14
232	10
233	11
234	7
235	13
236	17
237	8
238	25
239	20
240	13
241	21
242	7
243	12
244	16
245	23
246	18
247	31
248	6
249	17
250	13

Histogram

Computer Repair Times
Relative	Cumulative
Days	Frequency	Frequency	Percentage
0	0	0.000	0.0%
1	0	0.000	0.0%
2	0	0.000	0.0%
3	0	0.000	0.0%
4	0	0.000	0.0%
5	1	0.004	0.4%
6	2	0.008	1.2%
7	5	0.020	3.2%
8	12	0.048	8.0%
9	14	0.056	13.6%
10	19	0.076	21.2%
11	19	0.076	28.8%
12	23	0.092	38.0%
13	22	0.088	46.8%
14	20	0.080	54.8%
15	23	0.092	64.0%
16	18	0.072	71.2%
17	16	0.064	77.6%
18	9	0.036	81.2%
19	9	0.036	84.8%
20	8	0.032	88.0%
21	5	0.020	90.0%
22	4	0.016	91.6%
23	4	0.016	93.2%
24	0	0.000	93.2%
25	3	0.012	94.4%
26	2	0.008	95.2%
27	2	0.008	96.0%
28	0	0.000	96.0%
29	2	0.008	96.8%
30	0	0.000	96.8%
31	1	0.004	97.2%
32	0	0.000	97.2%
33	0	0.000	97.2%
34	1	0.004	97.6%
35	0	0.000	97.6%
36	2	0.008	98.4%
37	1	0.004	98.8%
38	1	0.004	99.2%
39	1	0.004	99.6%
40	1	0.004	100.0%
41	0	0.000	100.0%
42	0	0.000	100.0%

Repair Times

Frequency 0.0 1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0 9.0 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0 20.0 21.0 22.0 23.0 24.0 25.0 26.0 27.0 28.0 29.0 30.0 31.0 32.0 33.0 34.0 35.0 36.0 37.0 38.0 39.0 40.0 41.0 42.0 0.0 0.0 0.0 0.0 0.0 1.0 2.0 5.0 12.0 14.0 19.0 19.0 23.0 22.0 20.0 23.0 18.0 16.0 9.0 9.0 8.0 5.0 4.0 4.0 0.0 3.0 2.0 2.0 0.0 2.0 0.0 1.0 0.0 0.0 1.0 0.0 2.0 1.0 1.0 1.0 1.0 0.0 0.0

Days

Frequency

Statistical Calculations

Computer Repair Times
Days (x)	Frequency (f)	Frequency*Days	Days - Mean	(Days - mean )^2	Frequency*(Days - Mean)^2
0	0	0	-14.912	222.368	0.000
1	0	0	-13.912	193.544	0.000
2	0	0	-12.912	166.720	0.000
3	0	0	-11.912	141.896	0.000
4	0	0	-10.912	119.072	0.000
5	1	5	-9.912	98.248	98.248
6	2	12	-8.912	79.424	158.847
7	5	35	-7.912	62.600	312.999
8	12	96	-6.912	47.776	573.309
9	14	126	-5.912	34.952	489.324
10	19	190	-4.912	24.128	458.427
11	19	209	-3.912	15.304	290.771
12	23	276	-2.912	8.480	195.034
13	22	286	-1.912	3.656	80.426
14	20	280	-0.912	0.832	16.635
15	23	345	0.088	0.008	0.178
16	18	288	1.088	1.184	21.307
17	16	272	2.088	4.360	69.756
18	9	162	3.088	9.536	85.822
19	9	171	4.088	16.712	150.406
20	8	160	5.088	25.888	207.102
21	5	105	6.088	37.064	185.319
22	4	88	7.088	50.240	200.959
23	4	92	8.088	65.416	261.663
24	0	0	9.088	82.592	0.000
25	3	75	10.088	101.768	305.303
26	2	52	11.088	122.944	245.887
27	2	54	12.088	146.120	292.239
28	0	0	13.088	171.296	0.000
29	2	58	14.088	198.472	396.943
30	0	0	15.088	227.648	0.000
31	1	31	16.088	258.824	258.824
32	0	0	17.088	292.000	0.000
33	0	0	18.088	327.176	0.000
34	1	34	19.088	364.352	364.352
35	0	0	20.088	403.528	0.000
36	2	72	21.088	444.704	889.407
37	1	37	22.088	487.880	487.880
38	1	38	23.088	533.056	533.056
39	1	39	24.088	580.232	580.232
40	1	40	25.088	629.408	629.408
41	0	0	26.088	680.584	0.000
42	0	0	27.088	733.760	0.000
Sum	250	3728	8840.064
Mean	14.912	Variance	35.5022650602