Given at the bottom is the data copied froim excel

4.0OnlineCoffee is a coffee shop chain providing coffee, hot chocolate, and tea for customers who can enjoy their drinks by placing orders online and wait for the delivery. The shop is successful and currently has a plan to expanding its business. To make a good business strategy, the shop hires you as a data scientist to analyse their current data to extract valuable insights into their sales.

You are given an Excel file with data (DataExplorationAssignment.xlsx). Your work is to develop an analytic dashboard analytic dashboard for the managing team. The template of the dashboard is provided in the Excel file which consists of 4 tasks.

1. Product Statistics [25 marks]
2. You will need to find all products/drinks (with their sizes) the shop is selling and present the statistics of their price (mean, median, max, min). [10 marks] Example: If we have 3 products, each with 3 different sizes as follows then the max price will be 5.3 and the min price is 3.4.

Product	Given below	Standard	Large
Cappuccino	3.9	4.6	5.3
Chai Latte	3.9	4.6	5.3
Choc Duo	3.4	4.1	4.8

1. You will need create a chart to show the price of every product (with different sizes) [15 marks]Example: For the Cappuccino, we show the price of its Small, Standard, and Large sizes. Similar for other product.#Given below is the excel data which you need to work under

	ID	Coffee	Size	Unit cost
0	1652	Hot Chocolate	Standard	4.8
1	1146	Short Macchiato	Small	3.7
2	1706	Long Black	Standard	4.5
3	1938	Marble Mocha	Small	4.4
4	1628	Tea	Small	3.5
5	1630	Cappuccino	Large	5.3
6	1604	Marble Mocha	Standard	5.1
7	1628	Choc Duo	Large	5.8
8	1218	Cappuccino	Small	3.9
9	1316	Flat White	Small	3.9
10	1628	Chai Latte	Large	5.3
11	1668	Hot Chocolate	Standard	4.8
12	1253	Vienna	Small	4.2
13	1628	Espresso	Small	3.5
14	1557	Espresso	Small	3.5
15	1822	Marble Mocha	Small	4.4
16	1178	Dark Chocolate	Large	5.5
17	1604	Latte	Small	3.9
18	1148	Espresso	Small	3.5
19	1176	Short Macchiato	Small	3.7
20	1253	Piccolo Latte	Small	3.7
21	1668	Tea	Small	3.5
22	1668	Chai Latte	Small	3.9
23	1146	Latte	Small	3.9
24	1923	Cappuccino	Small	3.9
25	1604	Piccolo Latte	Small	3.7
26	1301	Chai Latte	Small	3.9
27	1923	Latte	Standard	4.6
28	1975	Piccolo Latte	Small	3.7
29	1121	Marble Mocha	Large	5.8
30	1019	Flat White	Standard	4.6
31	1315	Long Macchiato	Standard	4.5
32	1131	Long Macchiato	Standard	4.5
33	1666	Espresso	Small	3.5
34	1947	Tea	Large	3.7
35	1556	Choc Duo	Large	5.8
36	1167	Latte	Standard	4.6
37	1746	Choc Duo	Small	4.4
38	1121	Latte	Small	3.9
39	1557	Long Macchiato	Large	5.2
40	1829	Vienna	Large	5.6
41	1630	Tea	Large	3.7
42	1131	Vienna	Small	4.2
43	1198	Flat White	Large	5.3
44	1146	Espresso	Small	3.5
45	1267	Espresso	Small	3.5
46	1743	Long Macchiato	Large	5.2
47	1668	Marble Mocha	Small	4.4
48	1027	Hot Chocolate	Standard	4.8
49	1743	Hot Chocolate	Standard	4.8
50	1176	Piccolo Latte	Small	3.7
51	1569	Tea	Large	3.7
52	1829	Choc Mocha	Large	5.8
53	1746	Dark Chocolate	Standard	4.8
54	1923	White Chocolate	Small	4.1
55	1072	Long Black	Large	5.2
56	1292	Vienna	Standard	4.9
57	1253	Flat White	Standard	4.6
58	1938	Espresso	Small	3.5
59	1652	Long Macchiato	Small	3.8
60	1131	Espresso	Small	3.5
61	1975	Dark Chocolate	Small	4.1
62	1146	Vienna	Standard	4.9
63	1666	Espresso	Small	3.5
64	1829	Tea	Small	3.5
65	1569	Chai Latte	Large	5.3
66	1553	Piccolo Latte	Small	3.7
67	1292	Piccolo Latte	Small	3.7
68	1975	Latte	Large	5.3
69	1569	Tea	Small	3.5
70	1628	Tea	Large	3.7
71	1292	Espresso	Small	3.5
72	1668	Long Macchiato	Small	3.8
73	1666	Flat White	Small	3.9
74	1628	Chai Latte	Large	5.3
75	1743	Long Black	Small	3.8
76	1176	Flat White	Large	5.3
77	1604	Dark Chocolate	Standard	4.8
78	1301	Choc Duo	Large	5.8
79	1628	Piccolo Latte	Small	3.7
80	1316	Choc Duo	Standard	5.1
81	1820	Long Macchiato	Standard	4.5
82	1316	White Chocolate	Standard	4.8
83	1027	Long Black	Standard	4.5
84	1630	Vienna	Large	5.6
85	1630	Latte	Small	3.9
86	1405	Cappuccino	Standard	4.6
87	1652	Chai Latte	Small	3.9
88	1216	Dark Chocolate	Large	5.5
89	1668	Espresso	Small	3.5
90	1131	Long Black	Large	5.2
91	1405	Piccolo Latte	Small	3.7
92	1927	Cappuccino	Small	3.9
93	1131	Short Macchiato	Small	3.7
94	1975	Short Macchiato	Small	3.7
95	1628	Latte	Large	5.3
96	1975	Choc Duo	Small	4.4
97	1101	Hot Chocolate	Large	5.5
98	1146	Long Macchiato	Large	5.2
99	1167	Piccolo Latte	Small	3.7
100	1628	Choc Duo	Standard	5.1
101	1628	Vienna	Small	4.2
102	1292	Dark Chocolate	Small	4.1
103	1628	Dark Chocolate	Standard	4.8
104	1938	Short Macchiato	Small	3.7
105	1146	White Chocolate	Large	5.5
106	1315	Latte	Standard	4.6
107	1301	Choc Mocha	Small	4.4
108	1706	Long Macchiato	Standard	4.5
109	1743	Chai Latte	Large	5.3
110	1253	White Chocolate	Small	4.1
111	1072	Latte	Large	5.3
112	1927	Choc Duo	Large	5.8
113	1027	Long Black	Small	3.8
114	1326	Dark Chocolate	Large	5.5
115	1013	Chai Latte	Small	3.9
116	1326	White Chocolate	Small	4.1
117	1556	Short Macchiato	Small	3.7
118	1019	Espresso	Small	3.5
119	1860	Espresso	Small	3.5
120	1628	Espresso	Small	3.5
121	1668	Espresso	Small	3.5
122	1822	Flat White	Large	5.3
123	1604	Hot Chocolate	Standard	4.8
124	1628	Espresso	Small	3.5
125	1178	Marble Mocha	Small	4.4
126	1628	Piccolo Latte	Small	3.7
127	1148	Tea	Large	3.7
128	1315	Latte	Standard	4.6
129	1253	Espresso	Small	3.5
130	1628	Piccolo Latte	Small	3.7
131	1101	Choc Duo	Large	5.8
132	1923	Long Black	Large	5.2
133	1666	Espresso	Small	3.5
134	1057	Chai Latte	Standard	4.6
135	1553	Vienna	Standard	4.9
136	1630	Latte	Small	3.9
137	1315	Marble Mocha	Standard	5.1
138	1178	Chai Latte	Large	5.3
139	1131	Vienna	Standard	4.9
140	1198	Latte	Small	3.9
141	1131	Long Macchiato	Small	3.8
142	1628	Cappuccino	Large	5.3
143	1218	Marble Mocha	Small	4.4
144	1121	Choc Duo	Large	5.8
145	1121	Short Macchiato	Small	3.7
146	1019	Cappuccino	Small	3.9
147	1604	Marble Mocha	Standard	5.1
148	1553	Choc Mocha	Large	5.8
149	1267	Latte	Standard	4.6
150	1218	Hot Chocolate	Large	5.5
151	1938	Marble Mocha	Large	5.8
152	1326	Tea	Standard	3.6
153	1316	Latte	Large	5.3
154	1822	Dark Chocolate	Large	5.5
155	1860	Chai Latte	Large	5.3
156	1743	Chai Latte	Small	3.9
157	1628	Cappuccino	Standard	4.6
158	1746	Choc Duo	Small	4.4
159	1975	Cappuccino	Standard	4.6
160	1072	Long Black	Small	3.8
161	1860	Hot Chocolate	Standard	4.8
162	1148	Long Macchiato	Small	3.8
163	1668	Choc Mocha	Standard	5.1
164	1301	Choc Mocha	Small	4.4
165	1176	Vienna	Small	4.2
166	1121	Hot Chocolate	Small	4.1
167	1927	Flat White	Standard	4.6
168	1975	Marble Mocha	Small	4.4
169	1253	Choc Duo	Large	5.8
170	1569	Cappuccino	Standard	4.6
171	1938	Piccolo Latte	Small	3.7
172	1746	Latte	Large	5.3
173	1553	Flat White	Standard	4.6
174	1553	Long Black	Large	5.2
175	1292	White Chocolate	Small	4.1
176	1148	Short Macchiato	Small	3.7
177	1146	Choc Mocha	Small	4.4
178	1176	Cappuccino	Large	5.3
179	1405	Vienna	Standard	4.9
180	1553	Cappuccino	Small	3.9
181	1131	Choc Mocha	Small	4.4
182	1548	Dark Chocolate	Small	4.1
183	1829	Piccolo Latte	Small	3.7
184	1548	Vienna	Large	5.6
185	1975	Flat White	Standard	4.6
186	1101	Espresso	Small	3.5
187	1652	Choc Duo	Large	5.8
188	1706	Dark Chocolate	Small	4.1
189	1668	Tea	Large	3.7
190	1131	Hot Chocolate	Standard	4.8
191	1557	Tea	Large	3.7
192	1057	Cappuccino	Large	5.3
193	1326	Dark Chocolate	Large	5.5
194	1405	Long Black	Small	3.8
195	1019	Hot Chocolate	Small	4.1
196	1057	Hot Chocolate	Small	4.1
197	1938	Chai Latte	Large	5.3
198	1947	White Chocolate	Large	5.5
199	1628	Cappuccino	Large	5.3
200	1292	Tea	Large	3.7
201	1101	Dark Chocolate	Standard	4.8
202	1178	Chai Latte	Small	3.9
203	1743	Choc Mocha	Standard	5.1
204	1860	Piccolo Latte	Small	3.7
205	1146	Espresso	Small	3.5
206	1668	Choc Duo	Small	4.4
207	1148	Hot Chocolate	Large	5.5
208	1148	Hot Chocolate	Standard	4.8
209	1628	Vienna	Standard	4.9
210	1315	Dark Chocolate	Standard	4.8
211	1267	White Chocolate	Standard	4.8
212	1822	Choc Duo	Large	5.8
213	1027	Long Black	Small	3.8
214	1975	Cappuccino	Small	3.9
215	1548	Vienna	Standard	4.9
216	1743	Choc Mocha	Large	5.8
217	1822	Vienna	Standard	4.9
218	1548	Choc Mocha	Large	5.8
219	1315	Piccolo Latte	Small	3.7
220	1553	Vienna	Standard	4.9
221	1743	Dark Chocolate	Small	4.1
222	1628	White Chocolate	Small	4.1
223	1405	Hot Chocolate	Large	5.5
224	1027	Cappuccino	Small	3.9
225	1216	White Chocolate	Standard	4.8
226	1706	Choc Mocha	Standard	5.1
227	1628	White Chocolate	Small	4.1
228	1176	Hot Chocolate	Large	5.5
229	1975	Hot Chocolate	Large	5.5
230	1553	Hot Chocolate	Small	4.1
231	1569	Flat White	Standard	4.6
232	1548	Choc Mocha	Standard	5.1
233	1216	Marble Mocha	Standard	5.1
234	1057	Espresso	Small	3.5
235	1316	Short Macchiato	Small	3.7
236	1743	Dark Chocolate	Small	4.1
237	1292	White Chocolate	Small	4.1
238	1630	Choc Mocha	Standard	5.1
239	1822	Marble Mocha	Small	4.4
240	1548	Marble Mocha	Small	4.4
241	1326	Latte	Large	5.3
242	1267	Choc Duo	Standard	5.1
243	1326	Marble Mocha	Standard	5.1
244	1666	Flat White	Small	3.9
245	1216	Short Macchiato	Small	3.7
246	1923	Piccolo Latte	Small	3.7
247	1027	Latte	Standard	4.6
248	1131	Hot Chocolate	Standard	4.8
249	1131	Marble Mocha	Standard	5.1
250	1604	Vienna	Large	5.6
251	1648	Espresso	Small	3.5
252	1301	Flat White	Large	5.3
253	1947	Choc Mocha	Small	4.4
254	1019	Piccolo Latte	Small	3.7
255	1167	Long Macchiato	Standard	4.5
256	1628	Choc Duo	Large	5.8
257	1178	Long Black	Small	3.8
258	1315	Long Macchiato	Large	5.2
259	1556	Vienna	Large	5.6
260	1178	Cappuccino	Small	3.9
261	1556	Long Macchiato	Small	3.8
262	1822	Espresso	Small	3.5
263	1860	Hot Chocolate	Small	4.1
264	1553	Vienna	Small	4.2
265	1216	White Chocolate	Small	4.1
266	1569	Choc Mocha	Large	5.8
267	1178	Choc Duo	Small	4.4
268	1553	Piccolo Latte	Small	3.7
269	1101	Marble Mocha	Small	4.4
270	1923	Piccolo Latte	Small	3.7
271	1648	Long Macchiato	Small	3.8
272	1630	Long Macchiato	Small	3.8
273	1743	Latte	Standard	4.6
274	1131	Piccolo Latte	Small	3.7
275	1743	White Chocolate	Standard	4.8
276	1253	Espresso	Small	3.5
277	1316	Long Macchiato	Standard	4.5
278	1176	Dark Chocolate	Large	5.5
279	1316	Cappuccino	Small	3.9
280	1101	Latte	Large	5.3
281	1146	Piccolo Latte	Small	3.7
282	1057	Dark Chocolate	Standard	4.8
283	1556	Choc Duo	Small	4.4
284	1947	Choc Duo	Standard	5.1
285	1019	Long Macchiato	Standard	4.5
286	1938	Short Macchiato	Small	3.7
287	1548	Marble Mocha	Large	5.8
288	1553	Latte	Small	3.9
289	1326	White Chocolate	Small	4.1
290	1630	Long Macchiato	Large	5.2
291	1027	White Chocolate	Small	4.1
292	1072	White Chocolate	Large	5.5
293	1553	White Chocolate	Small	4.1
294	1829	Marble Mocha	Standard	5.1
295	1027	Short Macchiato	Small	3.7
296	1019	Choc Duo	Small	4.4
297	1947	Short Macchiato	Small	3.7
298	1668	Choc Mocha	Small	4.4
299	1820	Flat White	Standard	4.6
300	1267	Vienna	Standard	4.9
301	1938	Tea	Large	3.7
302	1013	Choc Duo	Standard	5.1
303	1927	Piccolo Latte	Small	3.7
304	1820	Flat White	Standard	4.6
305	1822	Choc Duo	Standard	5.1
306	1829	Long Black	Standard	4.5
307	1167	Cappuccino	Small	3.9
308	1057	Chai Latte	Small	3.9
309	1101	Espresso	Small	3.5
310	1829	Choc Mocha	Standard	5.1
311	1131	Cappuccino	Small	3.9
312	1148	Marble Mocha	Small	4.4
313	1315	Marble Mocha	Standard	5.1
314	1927	Short Macchiato	Small	3.7
315	1927	Short Macchiato	Small	3.7
316	1668	White Chocolate	Small	4.1
317	1557	Choc Mocha	Large	5.8
318	1326	White Chocolate	Small	4.1
319	1557	Vienna	Standard	4.9
320	1652	Hot Chocolate	Large	5.5
321	1569	Long Black	Small	3.8
322	1131	Long Black	Small	3.8
323	1822	Long Black	Large	5.2
324	1167	Piccolo Latte	Small	3.7
325	1013	Piccolo Latte	Small	3.7
326	1267	Long Black	Standard	4.5
327	1167	White Chocolate	Standard	4.8
328	1316	Choc Mocha	Small	4.4
329	1131	Latte	Small	3.9
330	1604	Espresso	Small	3.5
331	1746	Dark Chocolate	Standard	4.8
332	1027	Dark Chocolate	Small	4.1
333	1019	Dark Chocolate	Standard	4.8
334	1553	Flat White	Standard	4.6
335	1652	White Chocolate	Standard	4.8
336	1267	Long Black	Large	5.2
337	1630	Hot Chocolate	Large	5.5
338	1405	White Chocolate	Large	5.5
339	1648	Long Macchiato	Small	3.8
340	1019	Long Macchiato	Standard	4.5
341	1315	Latte	Small	3.9
342	1405	Latte	Standard	4.6
343	1176	Marble Mocha	Small	4.4
344	1822	Espresso	Small	3.5
345	1057	Choc Duo	Large	5.8
346	1292	Cappuccino	Standard	4.6
347	1216	Piccolo Latte	Small	3.7
348	1216	Short Macchiato	Small	3.7
349	1057	Vienna	Large	5.6
350	1301	Espresso	Small	3.5
351	1820	Latte	Standard	4.6
352	1569	Choc Duo	Small	4.4
353	1013	White Chocolate	Large	5.5
354	1746	White Chocolate	Large	5.5
355	1927	Long Macchiato	Standard	4.5
356	1027	Latte	Standard	4.6
357	1668	Long Macchiato	Large	5.2
358	1316	Dark Chocolate	Small	4.1
359	1027	Short Macchiato	Small	3.7
360	1267	Short Macchiato	Small	3.7
361	1829	Flat White	Standard	4.6
362	1218	Espresso	Small	3.5
363	1743	Piccolo Latte	Small	3.7
364	1706	Latte	Small	3.9
365	1013	Short Macchiato	Small	3.7
366	1668	Long Macchiato	Small	3.8
367	1630	Choc Duo	Standard	5.1
368	1923	Dark Chocolate	Small	4.1
369	1301	Long Macchiato	Large	5.2
370	1648	Vienna	Large	5.6
371	1628	Chai Latte	Large	5.3
372	1148	Espresso	Small	3.5
373	1746	Marble Mocha	Large	5.8
374	1218	Long Black	Large	5.2
375	1553	Marble Mocha	Large	5.8
376	1267	Chai Latte	Small	3.9
377	1706	Flat White	Standard	4.6
378	1820	Long Black	Standard	4.5
379	1604	Hot Chocolate	Small	4.1
380	1652	Long Black	Standard	4.5
381	1301	Cappuccino	Large	5.3
382	1218	Espresso	Small	3.5
383	1975	Tea	Standard	3.6
384	1548	Dark Chocolate	Small	4.1
385	1292	White Chocolate	Large	5.5
386	1648	Hot Chocolate	Small	4.1
387	1148	Long Macchiato	Large	5.2
388	1829	Hot Chocolate	Large	5.5
389	1178	White Chocolate	Large	5.5
390	1923	Piccolo Latte	Small	3.7
391	1131	Flat White	Small	3.9
392	1176	Long Black	Standard	4.5
393	1146	Choc Duo	Standard	5.1
394	1556	Piccolo Latte	Small	3.7
395	1822	Choc Mocha	Large	5.8
396	1178	Chai Latte	Standard	4.6
397	1628	Long Black	Standard	4.5
398	1553	Marble Mocha	Standard	5.1
399	1556	White Chocolate	Small	4.1
400	1553	Tea	Standard	3.6
401	1405	Choc Mocha	Standard	5.1
402	1820	Latte	Standard	4.6
403	1668	Short Macchiato	Small	3.7
404	1253	Vienna	Small	4.2
405	1167	Tea	Small	3.5
406	1131	Chai Latte	Small	3.9
407	1326	Flat White	Large	5.3
408	1829	Hot Chocolate	Large	5.5
409	1923	Hot Chocolate	Large	5.5
410	1292	Short Macchiato	Small	3.7
411	1652	Piccolo Latte	Small	3.7
412	1706	White Chocolate	Small	4.1
413	1706	Chai Latte	Standard	4.6
414	1822	Vienna	Small	4.2
415	1829	Flat White	Large	5.3
416	1975	Espresso	Small	3.5
417	1927	Piccolo Latte	Small	3.7
418	1743	Flat White	Large	5.3
419	1628	Dark Chocolate	Large	5.5
420	1648	Short Macchiato	Small	3.7
421	1668	Cappuccino	Standard	4.6
422	1628	White Chocolate	Small	4.1
423	1027	Hot Chocolate	Small	4.1
424	1326	Dark Chocolate	Small	4.1
425	1746	Long Macchiato	Small	3.8
426	1178	Choc Duo	Standard	5.1
427	1829	Choc Mocha	Large	5.8
428	1167	Espresso	Small	3.5
429	1820	Cappuccino	Small	3.9
430	1923	Choc Mocha	Large	5.8
431	1829	Long Black	Large	5.2
432	1548	Flat White	Large	5.3
433	1820	Long Black	Large	5.2
434	1292	Espresso	Small	3.5
435	1315	Tea	Standard	3.6
436	1648	Tea	Standard	3.6
437	1668	Espresso	Small	3.5
438	1178	Vienna	Large	5.6
439	1860	Cappuccino	Standard	4.6
440	1148	Flat White	Small	3.9
441	1548	Long Black	Standard	4.5
442	1315	Hot Chocolate	Small	4.1
443	1027	Hot Chocolate	Small	4.1
444	1628	Marble Mocha	Large	5.8
445	1746	Choc Duo	Standard	5.1
446	1860	Long Macchiato	Standard	4.5
447	1628	Short Macchiato	Small	3.7
448	1057	Tea	Standard	3.6
449	1860	Choc Duo	Large	5.8
450	1652	Latte	Large	5.3
451	1706	Choc Duo	Large	5.8
452	1628	Flat White	Standard	4.6
453	1148	Short Macchiato	Small	3.7
454	1630	Tea	Large	3.7
455	1101	Choc Mocha	Standard	5.1
456	1176	Chai Latte	Small	3.9
457	1253	Long Macchiato	Standard	4.5
458	1131	White Chocolate	Small	4.1
459	1820	Cappuccino	Large	5.3
460	1167	Long Macchiato	Large	5.2
461	1829	Choc Duo	Large	5.8
462	1628	Piccolo Latte	Small	3.7
463	1019	Choc Duo	Small	4.4
464	1947	Choc Duo	Large	5.8
465	1628	Cappuccino	Standard	4.6
466	1556	Marble Mocha	Standard	5.1
467	1216	Long Black	Small	3.8
468	1167	Piccolo Latte	Small	3.7
469	1326	Vienna	Large	5.6
470	1666	Dark Chocolate	Standard	4.8
471	1218	Cappuccino	Standard	4.6
472	1822	Long Macchiato	Standard	4.5
473	1315	Hot Chocolate	Small	4.1
474	1628	Hot Chocolate	Standard	4.8
475	1218	Choc Duo	Large	5.8
476	1013	Flat White	Small	3.9
477	1072	Choc Mocha	Small	4.4
478	1301	Piccolo Latte	Small	3.7
479	1292	Dark Chocolate	Standard	4.8
480	1292	Choc Mocha	Large	5.8
481	1556	Long Macchiato	Standard	4.5
482	1178	Dark Chocolate	Small	4.1
483	1019	Latte	Small	3.9
484	1326	Latte	Large	5.3
485	1822	Dark Chocolate	Standard	4.8
486	1947	White Chocolate	Large	5.5
487	1553	Tea	Large	3.7
488	1706	Vienna	Large	5.6
489	1176	Cappuccino	Standard	4.6
490	1557	Long Black	Standard	4.5
491	1253	Marble Mocha	Large	5.8
492	1829	Tea	Standard	3.6
493	1706	Long Black	Small	3.8
494	1820	Hot Chocolate	Small	4.1
495	1057	Choc Duo	Large	5.8
496	1628	Dark Chocolate	Small	4.1
497	1548	Vienna	Small	4.2
498	1553	Dark Chocolate	Standard	4.8
499	1553	White Chocolate	Standard	4.8