Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following sample data set lists the price of LASKO Fans at selected stores in Los Angeles. a) Construct a frequency distribution that has 6
The following sample data set lists the price of LASKO Fans at selected stores in Los Angeles. a) Construct a frequency distribution that has 6 classes, then use the frequency distribution to find: b) the mean, variance, standard deviation as well as relative frequency and cumulative frequency. d) Use only Excel formulas to showcase your answers
100 363 159 76 227 337 295 319 250 279 205 279 266 199 177 162 232 303 192 181 321 309 246 278 50 41 335 116 100 151 240 474 297 170 188 320 429 294 570 342 279 235 434 123 299
The following sample data set lists the price of LASKO Fans at selected stores in Los Angeles. | ||||
a) Construct a frequency distribution that has 6 classes, then use the frequency distribution to find: | ||||
b) the mean, variance, standard deviation as well as relative frequency and cumulative frequency. | ||||
d) Use only Excel formulas to showcase your answers |
100 |
363 |
159 |
76 |
227 |
337 |
295 |
319 |
250 |
279 |
205 |
279 |
266 |
199 |
177 |
162 |
232 |
303 |
192 |
181 |
321 |
309 |
246 |
278 |
50 |
41 |
335 |
116 |
100 |
151 |
240 |
474 |
297 |
170 |
188 |
320 |
429 |
294 |
570 |
342 |
279 |
235 |
434 |
123 |
299 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started