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.
Apply Chebyshev's Theorem and the Empirical Rule to both sets of data.
Compare your findings with your actual data.
Conclude whether Chebyshev's or Empirical Rule is more accurate with each of listing prices and square footages.