The Measure Phase

During a meeting with Anna Caniglia, Manager of Customer Operations at the Port of Miami, you sketched a high-level flowchart of the existing passenger check-in process (see below). She gave access to a set of raw data showing operational observations of a complete check-in process of 270 groups comprising over 1,000 passengers recently welcomed onboard the Coral Kalypso. (see below). This sample is considered representative of a normal boarding process of Kalypso cruise ships at the Port of Miami.

Deliverables You are to employ your knowledge of descriptive statistics and graphical methods to assess the elements below:

• Passenger arrival pattern
• Observed waiting time
• Observed service time

Make a short report with your observations to be discussed with Mr. Duran in the morning. Include the Excel file with your calculations.

Tips

Kalypso Tropical Cruises Inc.
Miami Welcome Operations
One-Day Passenger Activity
Group Party	Number of Passengers in Party	Arrival Time (min after open)	Waiting Time (min)	Service Time (min)	Number of Open Desks
1	4	0.000	0.0	11.8	5
2	4	1.852	0.0	9.7	5
3	3	3.691	0.0	6.3	5
4	6	5.516	0.0	18.9	5
5	3	7.328	0.0	9.9	5
6	3	9.127	0.5	9.4	5
7	3	10.913	0.6	8.6	5
8	4	12.686	1.4	13.1	5
9	3	14.445	1.4	6.3	5
10	4	16.191	1.5	12.2	5
11	4	17.924	1.7	9.0	5
12	3	19.644	2.2	9.9	5
13	3	21.351	2.3	7.0	5
14	4	23.044	2.4	9.0	5
15	5	24.724	3.0	12.4	5
16	4	26.391	2.6	5.3	5
17	3	28.045	3.2	9.4	5
18	4	29.686	2.7	8.0	5
19	4	31.313	3.6	8.0	6
20	5	32.927	3.0	12.4	6
21	3	34.528	3.8	9.4	6
22	4	36.116	3.5	10.5	6
23	3	37.691	4.4	9.9	6
24	4	39.252	4.5	9.3	6
25	3	40.800	4.7	7.0	6
26	5	42.335	4.8	12.4	6
27	3	43.857	5.8	6.1	6
28	4	45.366	3.9	12.0	6
29	4	46.861	6.3	10.5	6
30	3	48.343	5.4	8.6	6
31	5	49.812	7.0	5.2	6
32	4	51.268	5.6	9.7	6
33	4	52.711	6.1	5.3	6
34	5	55.556	7.2	9.3	6
35	3	56.959	7.4	9.3	6
36	3	57.652	8.0	6.1	6
37	2	58.349	7.6	2.2	6
38	3	59.726	7.6	7.9	6
39	4	61.089	6.9	6.7	7
40	2	62.439	6.6	2.2	7
41	3	63.776	8.3	9.3	7
42	3	65.100	6.9	9.6	7
43	5	66.411	8.5	5.2	7
44	5	67.708	8.2	9.3	7
45	4	68.992	9.3	9.7	7
46	4	70.263	9.2	9.0	7
47	2	71.521	8.2	4.4	7
48	4	72.766	10.3	9.0	7
49	2	73.997	9.2	2.2	7
50	5	75.215	9.5	12.4	7
51	3	76.420	9.5	6.3	7
52	6	77.612	10.4	17.1	7
53	4	78.791	10.5	9.0	7
54	5	79.956	10.1	5.2	7
55	5	81.108	10.1	5.2	7
56	4	82.247	11.1	9.3	7
57	5	83.373	10.5	9.3	7
58	3	84.486	13.1	8.6	7
59	4	85.585	9.5	6.7	7
60	5	86.671	10.0	15.2	7
61	3	87.744	12.3	9.4	7
62	2	88.804	10.8	4.4	7
63	3	89.851	11.3	7.9	7
64	4	90.884	11.4	12.0	8
65	6	91.904	12.7	18.9	8
66	5	92.911	12.4	15.2	8
67	4	93.905	14.0	10.5	8
68	6	94.886	13.7	17.1	8
69	5	95.853	11.8	15.2	8
70	3	96.807	14.2	6.1	8
71	3	97.748	13.9	6.1	8
72	4	98.676	16.6	8.0	8
73	5	99.591	15.1	5.2	8
74	3	100.492	15.2	7.9	8
75	3	101.380	14.9	9.6	8
76	6	102.255	14.1	18.9	8
77	4	103.117	14.6	9.7	8
78	4	103.966	15.7	12.2	8
79	3	104.801	16.6	9.6	8
80	3	105.623	16.2	9.6	8
81	5	106.432	18.8	12.4	8
82	3	107.228	16.3	7.9	8
83	3	107.618	24.7	7.3	8
84	3	108.011	14.6	9.3	8
85	4	108.394	20.9	9.3	8
86	4	108.780	15.2	9.0	8
87	6	109.536	15.1	17.1	8
88	4	110.279	17.9	5.3	8
89	4	111.009	16.3	9.7	8
90	4	111.726	16.1	11.8	8
91	6	112.429	17.4	17.1	8
92	3	113.119	14.9	6.1	8
93	4	113.796	18.4	8.0	8
94	4	114.460	17.6	11.8	8
95	2	115.111	19.5	4.4	8
96	6	115.748	16.9	17.1	8
97	4	116.372	20.9	8.0	8
98	3	116.983	16.7	9.3	8
99	4	117.581	17.3	13.1	8
100	3	118.166	22.1	9.9	8
101	4	118.451	22.1	10.5	8
102	2	118.737	18.9	2.2	8
103	3	119.295	16.5	8.6	8
104	4	119.840	21.0	10.5	9
105	5	120.372	20.0	12.4	9
106	3	120.891	18.8	7.3	9
107	6	121.396	20.0	17.1	9
108	3	121.888	22.4	6.1	9
109	3	122.367	18.3	9.3	9
110	5	122.833	22.2	15.2	9
111	4	123.059	23.3	9.3	9
112	6	123.286	23.4	17.1	9
113	4	123.725	22.2	6.7	10
114	3	124.151	21.9	8.6	10
115	4	124.564	22.3	12.0	10
116	3	124.964	22.8	6.1	10
117	4	125.351	22.6	10.5	10
118	4	126.084	18.8	11.8	10
119	3	126.765	19.1	7.9	10
120	3	127.086	21.3	7.9	10
121	3	127.393	18.5	9.9	10
122	3	127.687	23.1	8.6	10
123	2	128.236	23.2	4.4	10
124	6	128.732	17.1	17.1	10
125	6	128.960	22.4	18.9	10
126	3	129.175	19.2	7.0	10
127	3	129.377	25.0	7.0	10
128	4	129.579	23.3	9.3	10
129	3	129.754	24.1	9.9	10
130	5	129.929	22.9	9.3	10
131	4	130.104	25.7	5.3	10
132	3	130.279	22.1	9.9	10
133	3	130.629	25.2	7.9	10
134	4	130.979	20.3	12.0	10
135	2	131.329	25.7	4.4	10
136	4	131.679	22.0	13.1	10
137	4	132.029	23.0	9.7	10
138	4	132.729	27.1	12.2	10
139	4	133.079	24.5	12.0	10
140	4	133.429	26.0	13.1	10
141	3	133.807	20.7	9.3	10
142	4	134.009	21.4	5.3	10
143	4	134.237	21.3	9.3	10
144	4	134.518	20.8	6.7	10
145	4	134.839	20.7	12.2	10
146	2	135.033	23.1	4.4	10
147	5	135.240	22.5	9.3	10
148	4	135.461	23.3	9.0	10
149	4	135.695	20.5	13.1	10
150	4	135.942	23.5	9.7	10
151	6	136.202	20.2	17.1	10
152	4	137.476	20.0	8.0	10
153	3	138.759	17.3	7.0	10
154	5	139.143	18.3	15.2	10
155	4	139.530	17.7	5.3	10
156	4	139.941	19.2	12.2	10
157	4	140.354	22.1	5.3	10
158	4	140.786	18.6	9.7	10
159	4	141.231	16.9	6.7	10
160	4	141.689	19.0	13.1	10
161	3	141.924	21.7	6.1	10
162	3	142.160	19.1	7.9	10
163	3	142.402	20.2	6.1	10
164	2	142.645	21.2	2.2	10
165	3	143.143	15.4	7.0	10
166	5	143.398	21.7	5.2	10
167	4	143.654	18.3	9.3	10
168	4	144.178	18.4	5.3	10
169	4	144.715	18.9	12.0	10
170	4	145.266	20.7	11.8	10
171	6	145.830	18.8	17.1	10
172	3	146.407	19.8	7.3	10
173	3	146.997	14.5	9.6	10
174	3	147.600	17.9	9.3	10
175	5	148.217	13.0	12.4	10
176	3	148.847	15.2	8.6	10
177	6	149.490	12.0	17.1	10
178	6	150.146	17.0	17.1	10
179	6	150.815	14.9	18.9	10
180	4	151.498	15.7	12.2	10
181	6	152.194	15.2	17.1	10
182	4	152.903	16.1	9.7	10
183	6	153.625	14.7	18.9	10
184	3	154.360	13.6	7.0	10
185	3	155.109	14.0	7.9	10
186	4	155.871	14.8	12.2	10
187	4	156.646	15.6	12.0	10
188	4	157.434	12.7	11.8	10
189	5	157.833	20.8	9.3	10
190	4	158.235	13.1	6.7	10
191	3	159.050	13.0	9.4	10
192	4	159.878	14.3	9.3	10
193	2	160.719	13.6	2.2	10
194	6	161.573	13.2	18.9	9
195	6	162.440	13.5	17.1	9
196	3	163.321	12.7	7.3	9
197	3	164.215	14.7	9.4	9
198	3	165.122	12.5	6.3	9
199	5	166.042	10.8	5.2	9
200	3	166.975	9.8	7.3	9
201	2	167.922	12.1	2.2	9
202	4	168.882	10.9	11.8	9
203	4	169.855	9.9	5.3	9
204	3	170.841	12.1	8.6	9
205	3	171.840	11.3	9.6	9
206	2	172.345	23.3	4.4	9
207	4	172.853	12.2	6.7	9
208	5	173.879	9.5	15.2	9
209	2	174.918	10.0	2.2	9
210	4	175.970	10.2	13.1	9
211	4	177.035	9.0	13.1	9
212	4	177.573	24.0	12.0	9
213	4	178.114	9.1	8.0	9
214	3	179.206	10.6	9.3	9
215	5	180.311	9.5	12.4	9
216	3	181.429	8.8	9.9	9
217	4	181.993	18.9	11.8	9
218	3	182.560	8.6	7.3	9
219	3	183.131	24.5	7.3	9
220	4	183.705	9.9	9.0	9
221	3	184.863	8.4	7.3	9
222	5	186.034	7.9	15.2	9
223	6	187.218	7.7	17.1	9
224	3	188.415	6.1	9.4	9
225	3	189.626	7.7	6.3	9
226	5	190.850	6.4	5.2	9
227	6	192.087	6.0	18.9	8
228	3	192.710	22.0	6.3	8
229	4	193.337	7.7	12.0	8
230	3	194.600	6.6	9.9	8
231	5	195.877	7.3	9.3	8
232	5	197.167	5.7	15.2	8
233	5	197.816	25.2	5.2	8
234	4	198.470	5.3	8.0	8
235	4	199.786	5.6	12.2	8
236	5	201.115	6.6	9.3	8
237	4	201.220	4.0	11.8	8
238	3	202.458	6.4	9.3	8
239	3	203.814	5.0	9.6	8
240	4	205.183	4.1	6.7	8
241	5	206.565	5.3	9.3	8
242	4	207.960	3.9	9.3	8
243	4	208.662	21.2	9.0	8
244	4	209.369	3.9	6.7	8
245	2	212.226	3.5	4.4	8
246	3	213.001	23.0	6.3	8
247	3	214.771	20.7	7.0	8
248	6	214.887	22.0	17.1	8
249	3	215.174	4.2	9.4	8
250	3	216.135	3.6	7.0	8
251	6	216.610	3.2	17.1	7
252	3	217.551	1.4	9.6	7
253	3	218.998	2.8	9.6	7
254	5	220.780	3.1	12.4	7
255	2	221.113	2.6	4.4	7
256	4	221.776	23.5	10.5	7
257	3	222.640	2.6	8.6	7
258	3	224.181	2.3	6.3	7
259	4	225.735	2.1	12.2	7
260	4	227.302	1.7	10.5	7
261	6	228.112	20.8	17.1	7
262	3	230.475	1.5	9.4	7
263	3	232.082	0.0	7.3	7
264	4	232.204	26.1	10.5	7
265	6	233.702	0.0	18.9	7
266	5	235.335	0.0	15.2	7
267	4	236.981	0.0	13.1	7
268	3	238.640	0.0	6.3	7
269	2	240.313	0.0	2.2	7
270	4	241.999	0.0	8.0	7