Question

Problem 1 In Excel, for the data set, determine the mean, median, standard deviation, the minimum, maximum and count of data elements. State if the data is skewed, and if so how.

5.24	7.00	3.66	2.62	4.56	5.16
6.16	6.67	5.51	2.85	4.23	4.86
3.74	4.58	4.41	6.68	3.68	4.55
2.80	5.98	4.23	3.27	3.96	4.30
4.42	2.70	4.15	5.52	3.10	4.80
4.15	7.66	2.70	4.92	4.95	4.50
5.63	2.52	2.24	4.12	4.41	3.38
1.75	3.47	5.32	5.36	4.55	5.44
5.40	5.19	5.58	5.05	3.62	3.22
3.35	1.86	3.95	4.21	2.97	6.49
3.82	3.80	5.41	4.44	6.06	6.73
3.08	4.69	3.55	2.04	4.40	7.20
3.23	6.87	7.13	4.69	3.89	4.86
6.15	3.77	5.08	3.33	3.88	5.06
5.84	6.74	5.00	5.29	4.40	2.68
3.52	4.86	4.12	4.62	5.72	4.58
4.84	5.86	3.91	4.48	2.31	6.56
4.35	7.17	5.77	8.53	2.52	2.60
3.41	5.69	7.27	2.74	2.63	3.41
2.38	5.49	3.19	1.88	4.66	4.25
4.35	1.43	5.77	5.54	5.93	3.99
5.26	4.52	1.70	5.19	3.05	5.15
2.92	6.74	4.22	3.60	5.49	3.43
4.88	4.54	4.45	5.44	4.38	5.71
2.67	4.62	4.97	7.27	2.62	5.81

Answer 1

All the answers have been mentioned in the image below.