Searchthe Internet for a realty site.

ASSIGNMENT:

Searchthe Internet for a realty site.Selecta hometown of someone on your team in the search section on the website you have chosen. 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.Reviewthe new listings that populate.

Create an Excel^® spreadsheet with 4 columns, and create additional tabs in excel to create your frequency distribution, histogram, pie chat or bar graph, and your notes.

Include each of the following categories in the spreadsheet: Price, bedrooms, size, and bath

Prepare and create- a frequency distribution for listing prices, including relative frequencies.

Generate a histogram from your frequency distribution, again making sure you are consistent with the rules discussed in Chapter 2.

Summarize your findings from your frequency distribution and your histogram.

Create either a pie chart or a bar graph of the number of bedrooms in your 106 home

Calculate measures of central tendency for both listing prices and square footage. Those measures are mean, median, and mode.

Determine the quartiles for both listing prices and square footages.

Calculate measures of dispersion for both listing prices and square footages. Those measures are range, variance, and standard deviation.

ApplyChebyshev's Theorem and the Empirical Rule to both sets of data.

Compare your findings with your actual data.

Concludewhether Chebyshev's or Empirical Rule is more accurate with each of listing prices and square footages.