Question: Calculate the the mean, median, range, standard deviation, interquartile range, and coefficient of variation for Net Sales of All customers . Please show

  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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

The purpose of this assignment is to calculate key numerical measures from the Datafile of Pelican Stores using Microsoft Excel functions. Get descriptive statistics (mean, median, standard...

Q:

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Q:

CoursHeroTranscribedText: Question 1 The daily volume of a brokerage company follows a normal distribution. The director wants to estimate the daily volume negotiated. a) What size should have a...

Q:

A charged isolated metal sphere of diameter 10 cm has a potential of 8000 V relative to V = 0 at infinity. Calculate the energy density in the electric field near the surface of the sphere.

Q:

Assume Piaggio has unearned revenue. What is unearned revenue and where is it reported in financial statements?

Q:

How has corporate social responsibility evolved since the turn of the twentyfirst ce n tury? AppendixLO1

Q:

Identify some issues about financial market outcomes that behavioral economics attempts to address and explain.

Q:

1. One of the concerns raised by Carlisle was that if attorneys could be held liable for their reasonable misinterpretations of the FDCPAs requirements, there would be a flood of lawsuits against...

Q:

I am trying to display my results by inserting a main method within the car class I have included the prompt and the code I have so far. Programming in java Car Simulator For this assignment, you...

Q:

Ginger and Horace are looking to refinance their current home. Ginger makes $15.50 an hour at 40 hours a week, and Horace makes $80,000 a year. Their proposed monthly mortgage payment is $1,000 and...

Q:

I need help with problem 10. All of the information is attached to answer the question. Screen shots titled "Jimmy 1-4" is the information background needed to answer problem 10. Please show...

Q:

would appreciate freehand sketches for the top, side views, and front views. A >> () C D a 5 4 3 2 1 B 2.75 10 6 5 UNLESS OTHERWISE SPECIFIED: DIMENSIONS ARE IN MILLIMETERS SURFACE FINISH:...

Q:

The appendices are located in the course hero database under this file: 2020112605495120201125165956global_abc.1__1_.docx link:...

Q:

This is an individual project; all work must be your own. Contact me if you have questions. Part 1 : Data Analysis ( 7 0 points ) Your friend owns a company that offers 1 - day educational tours to...

Q:

A national licensure system could be implemented at the state or national level and would involve the issuance of a license based on a standardized set of criteria for the practice of health care...

Q:

PopUp Company produces two types of toasters, basic and deluxe.For the current period, the company reports the following data: Basic Toaster Deluxe Toaster Volume 20,000 units 5,000 units Machine...

Q:

E - commerce is so different from traditional commerce because of some unique features such as: A . Ubiquity, Global Reach, Universal Standards E . Only a . and b . C . BI , TCP / IP , Token rings B...

Q:

Answer the following two independent questions. a. MM Corporation is considering several proposed investments for the coming budget year. MM produces electrical apparatus for industrial complexes....

Q:

16. In the early years of Microsoft Bill Gates spent most of his time conducting business but also stayed involved in programming.

Q:

47. Because Microsoft has adopted an approach to R&D that is investment based it tends to produce results that are highly applied.

Q:

49. Bill Gates said that hed like to see the phrase go bing it/go bing it replace the phrase go google it/go google it.