Data Analysis Exercise

Customer	Time
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

As per the Given data draw the below charts in excel file and answer the below questions:

1) Histogram Chart

2) Box plot Chart

3) Calculate Central Tendency, Mean, Median, Quartiles

4) Which measure of central tendency, the mean or the median, is more appropriate in describing this distribution? Explain your reasoning

5) Variance and Standard Deviation

6) Recommendation