Question
4.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,
4.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 make 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.
5.Histogram, bar chart, and pie chart
Use the house price data and the bins data from problem 4 to create:
a.A histogram using the data analysis tool.
b.A bar chart
c.A pie chart
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
Financial Management for Public, Health and Not-for-Profit Organizations
Authors: Steven A. Finkler, Daniel L. Smith, Thad D. Calabrese, Robert M. Purtell
5th edition
1506326846, 9781506326863, 1506326862, 978-1506326849
