Computer Repair Times

Sample Repair Time (Days) 40

1 18
2 15
3 17 5
4 9
5 37 Time Response %
6 15 5 1.00 0.400%
7 8 6 2.00 0.800%
8 29 7 5.00 2.000%
9 10 8 12.00 4.800%
10 14 9 14.00 5.600%
11 17 10 19.00 7.600%
12 12 11 19.00 7.600%
13 13 12 23.00 9.200%
14 12 13 22.00 8.800%
15 11 14 20.00 8.000%
16 14 15 23.00 9.200%
17 13 16 18.00 7.200%
18 16 17 16.00 6.400%
19 13 18 9.00 3.600%
20 15 19 9.00 3.600%
21 16 20 8.00 3.200%
22 12 21 5.00 2.000%
23 34 22 4.00 1.600%
24 29 23 4.00 1.600%
25 13 24 - 0.000%
26 19 25 3.00 1.200%
27 12 26 2.00 0.800%
28 15 27 2.00 0.800%
29 16 28 - 0.000%
30 14 29 2.00 0.800%
31 15 30 - 0.000%
32 7 31 1.00 0.400%
33 40 32 - 0.000%
34 16 33 - 0.000%
35 11 34 1.00 0.400%
36 11 35 - 0.000%
37 10 36 2.00 0.800%
38 13 37 1.00 0.400%
39 14 38 1.00 0.400%
40 9 39 1.00 0.400%
41 18 40 1.00 0.400%
42 8
43 13
44 8
45 10
46 13 Time Response
47 16 5.00 1.00
48 9 6.00 2.00
49 9 7.00 5.00
50 12 8.00 12.00
51 16 9.00 14.00
52 9 10.00 19.00
53 15 11.00 19.00
54 17 12.00 23.00
55 38 13.00 22.00
56 11 14.00 20.00
57 15 15.00 23.00
58 16 16.00 18.00
59 10 17.00 16.00
60 9 18.00 9.00
61 25 19.00 9.00
62 15 20.00 8.00
63 7 21.00 5.00
64 11 22.00 4.00
65 19 23.00 4.00
66 13 24.00 -
67 12 25.00 3.00
68 20 26.00 2.00
69 12 27.00 2.00
70 13 28.00 -
71 11 29.00 2.00
72 8 30.00 -
73 14 31.00 1.00
74 10 32.00 -
75 12 33.00 -
76 15 34.00 1.00
77 17 35.00 -
78 10 36.00 2.00
79 13 37.00 1.00
80 18 38.00 1.00
81 26 39.00 1.00
82 14 40.00 1.00
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
Cumulative
0.400%
1.200%
3.200%
8.000%
13.600%
21.200%
28.800%
38.000%
46.800%
54.800%
64.000%
71.200%
77.600%
81.200%
84.800%
88.000%
90.000%
91.600%
93.200%
93.200%
94.400%
95.200%
96.000%
96.000%
96.800%
96.800%
97.200%
97.200%
97.200%
97.600%
97.600%
98.400%
98.800%
99.200%
99.600%
100.000%
Computer Repair Times

Sample Repair Time (Days)

1 18 Maximun
2 15 Minimum
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
Computer Repair Times

Sample Repair Time (Days)

1 18 Maximun 40
2 15 Minimum 5
3 17
4 9 Time
5 37 5
6 15 Using Fill series 6
7 8 7
8 29 8
9 10 9
10 14 10
11 17 11
12 12 12
13 13 13
14 12 14
15 11 15
16 14 16
17 13 17
18 16 18
19 13 19
20 15 20
21 16 21
22 12 22
23 34 23
24 29 24
25 13 25
26 19 26
27 12 27
28 15 28
29 16 29
30 14 30
31 15 31
32 7 32
33 40 33
34 16 34
35 11 35
36 11 36
37 10 37
38 13 38
39 14 39
40 9 40
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
 Frequency= Ctrl+Shift+ALT, Then to check CTRL+Shift+Enter

Response % Cumulative
1 0.400% 0.400%
2 0.800% 1.200%
5 2.000% 3.200%
12 4.800% 8.000%
14 5.600% 13.600%
19 7.600% 21.200%
19 7.600% 28.800%
23 9.200% 38.000%
22 8.800% 46.800%
20 8.000% 54.800%
23 9.200% 64.000%
18 7.200% 71.200%
16 6.400% 77.600%
9 3.600% 81.200%
9 3.600% 84.800%
8 3.200% 88.000%
5 2.000% 90.000%
4 1.600% 91.600%
4 1.600% 93.200%
0 0.000% 93.200%
3 1.200% 94.400%
2 0.800% 95.200%
2 0.800% 96.000%
0 0.000% 96.000%
2 0.800% 96.800%
0 0.000% 96.800%
1 0.400% 97.200%
0 0.000% 97.200%
0 0.000% 97.200%
1 0.400% 97.600%
0 0.000% 97.600%
2 0.800% 98.400%
1 0.400% 98.800%
1 0.400% 99.200%
1 0.400% 99.600%
1 0.400% 100.000%
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%
Repair Times
25
3 0 0.000 0.0%
20
4 0 0.000 0.0%
5 1 0.004 0.4% 15

Frequency
6 2 0.008 1.2% 10
7 5 0.020 3.2% 5
8 12 0.048 8.0% 0
9 14 0.056 13.6% 0 2 4 6 8 1 0 1 2 1 4 1 6 1 8 2 0 22 2 4 26 28 30 32
10 19 0.076 21.2%
11 19 0.076 28.8% Days
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%
pair Times

1 6 1 8 2 0 22 2 4 26 28 30 32 34 36 3 8 40 4 2

Days
Computer Repair Times

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

Mean 14.912 Variance

Frequency*(Days - Mean)^2
0.000
0.000
0.000
0.000
0.000
98.248
158.847
312.999
573.309
489.324
458.427
290.771
195.034
80.426
16.635
0.178
21.307
69.756
85.822
150.406
207.102
185.319
200.959
261.663
0.000
305.303
245.887
292.239
0.000
396.943
0.000
258.824
0.000
0.000
364.352
0.000
889.407
487.880
533.056
580.232
629.408
0.000
0.000
8840.064

35.502265060241