Housing Price Analysis

Refer to the Real Estate data provided in Column A of this sheet, which is a sample of the housing prices from a neighborhood in Ontario.

a. Use Excel functions to provide your answers next to to each of the descriptive statistics listed in the blue section.

b. Organize the data into a frequency distribution with seven class intervals (Outliers should not be included). Expand the frequency table and provide the following additional columns: relative frequency, cumulative frequency and mid point.

c. Draw the histogram to show the frequency distribution.

d. Draw the histogram to show the cumulative frequency distribution.

e. Calculate the mean, median and sample standard deviation based on the frequency distribution you developed in Question 2.

(Note: They are different from the values in blue area. You should use the formula for grouped data and information in the frequency distribution table. Please use the formula for median and standard deviation below.)

f. Draw box-plot based on the values in blue area. (You can draw it manually by inserting the appropriate shapes.)

Question Part I

Minimum Value

Maximum Value

Range

First Quartile

Second Quartile (Median)

Third Quartile

Inter Quartile Range

30 Percentile

Lower Limit of Inner Fence

Upper Limit of Inner Fence

Lower Limit of Outer Fence

Upper Limit of Outer Fence

Percentage of Prices less than $500,000

Number of Mild Outliers

Number of Extreme Outliers

Sample Mean

Sample Standard Deviation

List Price

$ 204,900

$ 210,000

$ 239,900

$ 269,000

$ 279,900

$ 289,900

$ 297,900

$ 298,800

$ 309,900

$ 319,900

$ 349,800

$ 349,900

$ 359,900

$ 389,900

$ 398,800

$ 469,900

$ 578,000

$ 605,000

$ 615,000

$ 628,000

$ 632,000

$ 635,000

$ 640,000

$ 649,900

$ 702,500

$ 742,000

$ 756,000

$ 757,000

$ 778,200

$ 821,000

$ 825,000

$ 827,000

$ 832,100

$ 839,000

$ 839,500

$ 841,000

$ 850,000

$ 855,000

$ 858,000

$ 859,000

$ 886,000

$ 890,000

$ 899,100

$ 921,000

$ 925,000

$ 985,000

$ 992,300

$ 995,000

$ 1,025,000

$ 1,165,000

$ 1,198,000

$ 1,214,900

$ 1,219,877

$ 1,228,500

$ 1,229,900

$ 1,229,900

$ 1,234,900

$ 1,235,800

$ 1,244,900

$ 1,247,000

$ 1,248,000

$ 1,248,000

$ 1,249,000

$ 1,249,900

$ 1,249,900

$ 1,250,000

$ 1,254,800

$ 1,258,000

$ 1,259,900

$ 1,265,000

$ 1,270,000

$ 1,274,000

$ 1,274,900

$ 1,275,900

$ 1,279,888

$ 1,279,900

$ 1,288,000

$ 1,292,500

$ 1,299,900

$ 1,300,000

$ 1,319,000

$ 1,319,900

$ 1,328,000

$ 1,329,000

$ 1,338,000

$ 1,349,500

$ 1,358,000

$ 1,359,800

$ 1,359,900

$ 1,365,000

$ 1,372,000

$ 1,378,877

$ 1,379,900

$ 1,380,000

$ 1,389,900

$ 1,391,000

$ 1,410,000

$ 1,450,000

$ 1,479,900

$ 1,485,000

$ 1,496,000

$ 1,496,000

$ 1,499,000

$ 1,565,900

$ 1,568,000

$ 1,598,000

$ 1,609,000

$ 1,621,500

$ 1,625,000

$ 1,635,000

$ 1,725,800

$ 1,792,100

$ 1,807,000

$ 1,835,000

$ 1,836,000

$ 1,850,000

$ 1,980,000

$ 2,120,000

$ 2,150,000

$ 2,164,900

$ 2,250,000

$ 2,253,000

$ 2,350,000

$ 3,360,000