4 Restaurant Service

Customer Time to serve
1 55
2 54
3 25
4 28
5 142
6 49
7 38
8 10
9 13
10 47
11 47
12 40
13 75
14 57
15 53
16 73
17 94
18 62
19 46
20 20
21 34
22 70
23 33
24 34
25 65
26 23
27 58
28 31
29 24
30 18
31 75
32 5
33 46
34 8
35 16
36 96
37 55
38 43
39 90
40 44
41 48
42 23
43 85
44 71
45 15
46 21
47 51
48 63
49 90
50 21
51 77
52 73
53 44
54 96
55 69
56 74
57 53
58 60
59 22
60 78
61 96
62 16
63 64
64 25
65 61
66 78
67 25
68 86
69 41
70 68
71 43
72 80
73 26
74 46
75 37
76 48
77 81
78 29
79 59
80 65
81 77
82 50
83 108
84 91
85 57
86 28
87 70
88 39
89 30
90 88
91 64
92 39
93 46
94 60
95 110
96 60
97 21
98 11
99 109
100 31
101 47
102 23
103 52
104 65
105 44
106 52
107 122
108 12
109 47
110 50
111 32
112 97
113 65
114 31
115 43
116 63
117 25
118 35
119 101
120 71
121 17
122 26
123 37
124 52
125 48
126 69
127 87
128 49
129 141
130 43
131 30
132 79
133 39
134 31
135 39
136 14
137 35
138 27
139 68
140 69
141 58
142 97
143 32
144 58
145 85
146 46
147 78
148 80
149 69
150 46
151 35
152 32
153 51
154 56
155 73
156 43
157 93
158 78
159 43
160 44
161 83
162 51
163 60
164 60
165 53
166 70
167 66
168 53
169 102
170 39
171 6
172 51
173 31
174 18
175 49
176 55
177 28
178 38
179 49
180 80
181 78
182 49
183 64
184 67
185 24
186 41
187 27
188 40
189 72
190 56
191 11
192 74
193 19
194 65
195 31
196 22
197 31
198 75
199 63
200 43
4. The data gives information on the time taken to serve 200 customers at a restaurant.
a. Create a histogram of the service time. Create a box-whisker plot of the service time. What can you sa
b. Calculate the mean, median, first and third quartile of the time taken to serve.
c. Is the mean or median more appropriate to suggest the typical service time? Explain.
d. Calculate the variance and standard deviation of the service time. What do they tell you?
e. Can you make an educated guess whether the empirical rules apply based on the shape of the histogr
f. Can you confirm your guess by estimating the values of the empirical rules
t a restaurant.
service time. What can you say about the distribution of the data?
me? Explain.
do they tell you?
ed on the shape of the histogram?
Time to serve
55
54 a This chart isn't available in your version of Excel.
25
28 Editing this shape or saving this workbook into a different file form
142 chart.
49
38
10
13
47
47
40
75
57
53
73
94
62 The minimum time to serve any customer is 5 sec and the average time to serve any cus
46 The distribution is right skewed and the service time is mostly distributed between 20 se
20
34
70 b
33 Mean 52.805
34
65 Median 50
23
58 First Quartile 32
31
24 Third Quartile 69.75
18
75
5
46 c The median is more appropriate to suggest the typical service time if the data is skewed
8
16
96 d Variance 661.82
55
43 Standard deviation 25.73
90
44 Variance measures the average squared deviation from the mean, while the standard de
48 Standard Deviation tells us that how much deviated the data is from the mean of the dat
23
85
71 e Based on the shape of the histogram, I would say that it is unlikely that the empirical rule
15
21
51
63
90 Emp Rule
21 f Mean 52.81 68%
77 Stnd Dev 25.73 95%
73 99.70%
44
96 The emperical rule calculation suggest that this data is skewed or is not normally distribu
69
74
53
60
22
78
96
16
64
25
61
78
25
86
41
68
43
80
26
46
37
48
81
29
59
65
77
50
108
91
57
28
70
39
30
88
64
39
46
60
110
60
21
11
109
31
47
23
52
65
44
52
122
12
47
50
32
97
65
31
43
63
25
35
101
71
17
26
37
52
48
69
87
49
141
43
30
79
39
31
39
14
35
27
68
69
58
97
32
58
85
46
78
80
69
46
35
32
51
56
73
43
93
78
43
44
83
51
60
60
53
70
66
53
102
39
6
51
31
18
49
55
28
38
49
80
78
49
64
67
24
41
27
40
72
56
11
74
19
65
31
22
31
75
63
43
ur version of Excel. This chart isn't available in your version of Excel.
his workbook into a different file format will permanently break the Editing this shape or saving this workbook into a d
permanently break the chart.
nd the average time to serve any customer is around 50 sec.

e is mostly distributed between 20 sec to 80 sec.
ical service time if the data is skewed or has outliers, as it is less affected by extreme values. The mean is sensitive to outliers.
rom the mean, while the standard deviation is the square root of the variance. They provide insights into the spread or variability of the s
d the data is from the mean of the data.
hat it is unlikely that the empirical rules apply

Lower Bound Upper Bound
27.08 78.53
1.35 104.26
-24.37 129.98
a is skewed or is not normally distributed.

lable in your version of Excel.
or saving this workbook into a different file format will

the chart.
nsitive to outliers.
e spread or variability of the service time data.

4 Restaurant Service

Uploaded by

Copyright:

Available Formats

4 Restaurant Service

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

4 Restaurant Service

Uploaded by

Copyright:

Available Formats

Customer Time to serve

nd the average time to serve any customer is around 50 sec.

hat it is unlikely that the empirical rules apply

a is skewed or is not normally distributed.

or saving this workbook into a different file format will

e spread or variability of the service time data.

You might also like