1. Calculate the the mean, median, range, standard deviation, interquartile range, and coefficient of variation for "Net Sales" of All customers. Please show step by step using excel.

Customer	Type of Customer	Net Sales	Items	Payment	Marital Status	Age
1	Regular	55.23	1	Visa	Married	44
2	Regular	60.23	1	Visa	Single	24
3	Promotional	91.13	2	Mastercard	Married	48
4	Promotional	81.93	3	Visa	Married	32
5	Promotional	31.60	1	Visa	Single	42
6	Promotional	78.00	2	Discover	Married	68
7	Promotional	80.40	2	Mastercard	Married	48
8	Promotional	60.23	2	Visa	Married	48
9	Regular	25.00	1	Visa	Married	46
10	Promotional	42.33	1	Visa	Single	20
11	Promotional	86.80	3	Discover	Married	38
12	Promotional	28.44	1	Discover	Married	44
13	Promotional	47.20	2	Mastercard	Married	46
14	Promotional	253.00	9	Visa	Married	30
15	Promotional	49.23	2	Mastercard	Married	32
16	Regular	29.50	1	Visa	Married	48
17	Promotional	39.50	2	Visa	Married	48
18	Regular	66.00	3	Visa	Married	46
19	Promotional	73.93	2	Visa	Married	28
20	Promotional	23.96	5	Mastercard	Married	44
21	Regular	79.73	1	Mastercard	Single	22
22	Regular	22.50	1	Visa	Married	40
23	Regular	117.73	4	Mastercard	Married	36
24	Promotional	14.82	1	Mastercard	Married	32
25	Promotional	68.73	4	Mastercard	Married	32
26	Regular	49.50	1	Visa	Single	24
27	Promotional	78.00	2	Visa	Married	30
28	Promotional	157.53	5	Discover	Married	28
29	Regular	33.23	1	Discover	Married	32
30	Promotional	95.20	4	Mastercard	Married	54
31	Promotional	116.23	5	Visa	Married	56
32	Regular	123.50	2	Discover	Married	48
33	Promotional	33.15	1	Discover	Married	54
34	Regular	144.00	6	Visa	Single	48
35	Promotional	20.80	1	Visa	Married	62
36	Regular	50.23	1	Mastercard	Married	32
37	Promotional	42.33	1	Mastercard	Single	28
38	Promotional	102.40	1	Mastercard	Married	36
39	Promotional	123.10	6	Visa	Married	54
40	Promotional	57.23	2	Visa	Married	32
41	Promotional	58.00	4	Visa	Married	32
42	Promotional	263.73	9	Visa	Married	30
43	Promotional	266.00	7	Mastercard	Married	50
44	Regular	113.23	2	Mastercard	Single	42
45	Promotional	94.00	3	Visa	Single	22
46	Promotional	70.23	2	Visa	Married	34
47	Promotional	176.62	6	Mastercard	Married	38
48	Promotional	59.91	3	Mastercard	Single	30
49	Promotional	63.64	3	Mastercard	Married	30
50	Promotional	50.23	2	Visa	Married	48
51	Regular	54.50	3	Mastercard	Married	40
52	Promotional	70.82	4	Mastercard	Married	38
53	Promotional	171.13	9	Mastercard	Married	40
54	Promotional	67.25	2	Mastercard	Married	46
55	Promotional	19.50	4	Visa	Married	46
56	Promotional	40.75	1	Visa	Married	60
57	Promotional	50.33	1	Mastercard	Married	62
58	Regular	55.23	1	Mastercard	Married	54
59	Promotional	65.20	4	Visa	Married	46
60	Promotional	111.14	4	Visa	Married	28
61	Promotional	129.53	5	Visa	Married	68
62	Promotional	69.23	4	Visa	Married	36
63	Promotional	75.23	2	Mastercard	Married	46
64	Promotional	82.13	2	Mastercard	Single	36
65	Promotional	44.80	6	Mastercard	Married	56
66	Promotional	58.33	2	Mastercard	Married	30
67	Promotional	113.00	4	Discover	Single	50
68	Promotional	155.93	9	Mastercard	Married	46
69	Promotional	50.33	2	Mastercard	Married	60
70	Promotional	119.53	1	Mastercard	Married	46
71	Regular	99.73	2	Visa	Married	54
72	Promotional	31.60	1	Visa	Single	20
73	Regular	50.73	1	Visa	Married	34
74	Promotional	113.13	1	Mastercard	Married	36
75	Promotional	88.73	2	Visa	Married	30
76	Promotional	160.40	9	Visa	Married	40
77	Promotional	128.23	6	Mastercard	Married	50
78	Promotional	45.22	2	Visa	Married	74
79	Promotional	55.53	6	Mastercard	Married	56
80	Regular	65.23	3	Mastercard	Married	40
81	Regular	40.00	1	Visa	Married	34
82	Promotional	73.13	1	Mastercard	Married	54
83	Regular	69.00	1	Mastercard	Single	22
84	Promotional	63.20	2	Visa	Married	28
85	Promotional	146.80	5	Mastercard	Married	28
86	Regular	35.73	1	Mastercard	Married	46
87	Regular	40.23	1	Visa	Single	36
88	Promotional	57.93	2	Visa	Married	46
89	Promotional	152.33	3	Mastercard	Married	38
90	Promotional	57.60	6	Mastercard	Married	42
91	Regular	49.73	2	Visa	Married	42
92	Promotional	59.50	2	Mastercard	Married	34
93	Regular	37.50	2	Mastercard	Married	44
94	Promotional	30.23	4	Mastercard	Married	46
95	Promotional	117.50	6	Visa	Married	50
96	Promotional	71.40	2	Mastercard	Single	36
97	Regular	64.73	2	Visa	Married	34
98	Regular	39.50	1	Visa	Married	44
99	Promotional	53.60	5	Visa	Married	54
100	Promotional	39.60	1	Discover	Married	62
101	Promotional	68.33	6	Visa	Married	42
102	Regular	39.00	2	Visa	Married	42
103	Promotional	84.74	4	Mastercard	Married	62
104	Promotional	46.50	2	Visa	Married	32
105	Regular	52.50	2	Mastercard	Married	58
106	Promotional	287.59	10	Visa	Married	52
107	Promotional	63.20	3	Mastercard	Married	44
108	Regular	60.23	2	Mastercard	Married	32
109	Promotional	70.64	3	Visa	Single	30
110	Promotional	187.35	6	Visa	Married	38
111	Promotional	298.32	10	Visa	Married	52
112	Regular	50.23	1	Visa	Married	44
113	Promotional	121.87	4	Mastercard	Married	28
114	Promotional	203.53	5	Mastercard	Single	42
115	Promotional	104.73	3	Mastercard	Single	22
116	Promotional	97.53	3	Mastercard	Married	38
117	Regular	76.73	3	Visa	Married	46
118	Regular	33.23	1	Mastercard	Married	40
119	Promotional	55.95	2	Mastercard	Married	74
120	Regular	84.73	2	Mastercard	Single	20
121	Regular	75.00	1	Visa	Married	52
122	Promotional	42.33	1	Visa	Married	40
123	Regular	102.50	2	Mastercard	Single	42
124	Regular	74.00	2	Mastercard	Single	20
125	Promotional	75.93	4	Mastercard	Married	46
126	Promotional	111.13	5	Visa	Married	28
127	Regular	68.73	1	Mastercard	Single	78
128	Regular	89.00	2	Visa	Married	54
129	Promotional	192.80	5	Visa	Single	42
130	Regular	84.73	2	Mastercard	Married	42
131	Promotional	62.40	1	Visa	Married	54
132	Promotional	71.20	3	Mastercard	Married	32
133	Promotional	56.52	2	Visa	Married	46
134	Regular	49.50	2	Visa	Married	32
135	Regular	63.23	2	Visa	Married	58
136	Promotional	105.93	4	Mastercard	Married	54
137	Regular	159.75	5	Visa	Married	72
138	Promotional	64.50	2	Mastercard	Married	46
139	Promotional	95.05	8	Visa	Married	54
140	Promotional	240.23	17	Visa	Married	30
141	Regular	40.23	1	Discover	Married	48
142	Promotional	100.40	5	Mastercard	Married	28
143	Promotional	39.60	2	Mastercard	Married	60
144	Promotional	25.55	1	Visa	Married	32
145	Promotional	31.60	1	Mastercard	Single	28
146	Promotional	34.53	2	Mastercard	Married	38
147	Regular	39.50	1	Visa	Married	32
148	Promotional	39.17	1	Mastercard	Married	44
149	Promotional	47.60	2	Mastercard	Married	30
150	Promotional	198.80	13	Mastercard	Married	42
151	Promotional	22.42	1	Visa	Married	54
152	Regular	48.23	2	Visa	Married	44
153	Promotional	145.20	9	Mastercard	Married	46
154	Promotional	18.00	1	Mastercard	Married	70
155	Regular	44.50	1	Visa	Married	54
156	Promotional	276.73	7	Mastercard	Married	50
157	Promotional	13.23	5	Visa	Married	44
158	Promotional	53.20	6	Visa	Single	30
159	Regular	74.00	2	Mastercard	Married	42
160	Regular	107.00	4	Visa	Married	36
161	Regular	55.23	1	Mastercard	Married	36
162	Regular	154.73	6	Mastercard	Single	48
163	Promotional	31.53	1	Mastercard	Married	62
164	Promotional	28.73	1	Mastercard	Married	70
165	Promotional	46.00	3	Mastercard	Married	44
166	Promotional	63.93	6	Mastercard	Single	30
167	Promotional	81.55	4	Mastercard	Married	38
168	Regular	58.00	1	Mastercard	Single	78
169	Regular	85.73	1	Visa	Married	52
170	Promotional	155.32	5	Mastercard	Married	30
171	Promotional	105.50	5	Visa	Married	56
172	Promotional	58.50	4	Visa	Married	36
173	Promotional	31.60	1	Mastercard	Married	40
174	Promotional	23.80	2	Mastercard	Married	38
175	Promotional	56.73	3	Visa	Married	44
176	Promotional	105.78	8	Visa	Married	54
177	Promotional	141.60	3	Mastercard	Married	38
178	Promotional	209.53	13	Mastercard	Married	42
179	Promotional	108.80	1	Mastercard	Married	46
180	Promotional	73.93	3	Discover	Married	44
181	Promotional	123.73	4	Discover	Single	50
182	Regular	22.50	1	Mastercard	Married	32
183	Regular	44.50	1	Visa	Married	36
184	Promotional	38.50	2	Visa	Married	32
185	Regular	54.00	2	Mastercard	Married	34
186	Promotional	95.47	4	Mastercard	Married	62
187	Promotional	133.83	6	Visa	Married	54
188	Promotional	118.80	5	Visa	Married	68
189	Promotional	49.50	2	Mastercard	Married	48
190	Promotional	166.05	5	Mastercard	Married	30
191	Promotional	229.50	17	Visa	Married	30
192	Regular	29.50	1	Visa	Single	36
193	Promotional	88.73	2	Mastercard	Married	68
194	Promotional	74.37	3	Visa	Married	30
195	Regular	44.50	1	Visa	Married	44
196	Promotional	42.33	1	Mastercard	Single	42
197	Promotional	30.02	1	Mastercard	Married	60
198	Promotional	64.33	5	Discover	Married	54
199	Regular	134.23	2	Visa	Married	48
200	Regular	170.48	5	Discover	Married	72