Search the Internet for a realty site. Select a city or town of interest to the team.
Question:
Search the Internet for a realty site.
Select a city or town of interest to the team. When all of the listings populate, make sure that the sort criteria reads "New Listings." This ensures that you are searching a random cross-section of listings rather than favoring one price range.
Review the new listings that populate.
Create an Excel® spreadsheet with 4 columns of the first 100 single family homes listed, not including condominiums or townhouses.
Include each of the following categories in the spreadsheet: Property address, listing price, square footage, and number of bedrooms.
Prepare a frequency distribution for listing prices, using Megastat.
Create your frequency distribution by using some of the rules or suggestions coming from your book chapters. You could start by just letting Megastat do its own thing (ie, no inputs for class width, or lowest number of first class, and finish by trying some settings based on the discussion in your text or in class.
Generate a histogram from your frequency distribution, again making sure you are consistent with the rules discussed in Chapter 2. or in class.
Summarize your findings from your frequency distribution and your histogram.
Create either a pie chart of the number of bedrooms in your 100 homes.
Evaluate your visual aid.
Calculate measures of central tendency (or location as discussed in class) for both listing prices and square footages. Those measures are mean, median, and mode.
Determine the quartiles for both listing prices and square footages. There is a selection for this in the Descriptive Statistics function of Megastat. So megastat will be the easiest way for the team to accomplish this.
Calculate measures of dispersion for both listing prices and square footages. Those measures are range, variance, and standard deviation. Again I would use Megastat.
Analyze your data with respect to its compliance (or lack of same) with Chebyshev's Theorem and the Empirical Rule. do this for both sets (listing prices, and square footage). Megastat will do this for Empirical Rule, You will need to do this manually for Chebyshevs.
Conclude whether Chebyshev's or Empirical Rule is more accurate with each of listing prices and square footages.
Financial and Managerial Accounting
ISBN: 978-0132497978
3rd Edition
Authors: Horngren, Harrison, Oliver