According to Zillow.com, here is a list of the prices of the property sold (in t
ID: 3048718 • Letter: A
Question
According to Zillow.com, here is a list of the prices of the property sold (in thousands) in Phoenix, AZ November 9 - 13, 2017. Use Excel’s capability (=FREQUENCY()) to create a frequency distribution using 5 bins.
247
190
210
211
415
567
195
187
150
313
280
305
202
326
170
572
182
195
325
290
86
182
229
405
442
210
152
155
308
314
520
195
200
572
170
173
208
330
369
590
57
268
247
175
175
180
265
244
490
290
Hint: To score the full points for this question, set it up so that Excel calculate the bins for you. This way if you change the data the bins are changed automatically.
247
190
210
211
415
567
195
187
150
313
280
305
202
326
170
572
182
195
325
290
86
182
229
405
442
210
152
155
308
314
520
195
200
572
170
173
208
330
369
590
57
268
247
175
175
180
265
244
490
290
Explanation / Answer
Frequency distribution using 5 bins
Here class width calculted as (max - min)/5 = (590 - 57)/5 = 107
Bin Frequency 51-158 5 159-266 24 267-374 12 375-482 3 483-590 6Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.