Frequency Distribution According to Zillow.com, here is a list of the prices of
ID: 3239808 • Letter: F
Question
Frequency Distribution
According to Zillow.com, here is a list of the prices of the property sold (in thousands) in Washington, DC June 29 – 30, 2016. Use Excel’s capability (=FREQUENCY()) to create a frequency distribution using 5 bins.
316
580
192
440
1860
2333
1775
844
843
785
265
1315
721
368
763
536
406
1261
1875
1213
299
205
825
1318
1451
625
1473
2093
449
1879
869
920
1700
2450
1460
1562
1380
888
1750
495
240
2250
1420
585
1456
949
1435
1475
945
645
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.
316
580
192
440
1860
2333
1775
844
843
785
265
1315
721
368
763
536
406
1261
1875
1213
299
205
825
1318
1451
625
1473
2093
449
1879
869
920
1700
2450
1460
1562
1380
888
1750
495
240
2250
1420
585
1456
949
1435
1475
945
645
Explanation / Answer
X Frequency 0-499 11 500-999 16 1000-1499 12 1500-1999 7 2000-2500 4 Grand Total 50
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.