Zillow.com prices of the property sold (in thousands) in Washington, DC June 29-
ID: 3252598 • Letter: Z
Question
Zillow.com prices of the property sold (in thousands) in Washington, DC June 29-30, 2016 follows:
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
To create a 5-bin frequency distribution using Excel’s array formula {=FREQUENCY()}:
a. Compute the minimun and maximun of the data using Excel functions = MIN and =MAX
b. Compute the bin width equal to 1.05 x (max-min)/number of bins
c. Compute the bin upper limits. The first bin upper limit = minimum + width. Bins must be equally spaced.
d. Compute frequencies of you bins. Next to the bin values, select a range of cells on the same rows as the bin values. Type = FREQUENCY and finish the inputs, and type). Enter the array formula by typing CTRL + SHIFT + ENTER. The array formula will display with curly braces like {=frequency(your inputs)}. If you have completed each step correctly your bins and frequencies will be:
Could you please include the formulas so I can do it in excel? Thanks
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
DataSet Put data into A1:A50
Problem A
Formula
Problem B
Formula
Problem C & D
Formula
192 205 240 265 299 316 368 406 440 449 495 536 580 585 625 645 721 763 785 825 843 844 869 888 920 945 949 1213 1261 1315 1318 1380 1420 1435 1451 1456 1460 1473 1475 1562 1700 1750 1775 1860 1875 1879 2093 2250 2333 2450Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.