The data in the following table represent the number of days that a random sample of homes in four price ranges were on the market before being sold for three different competing real estate companies in a local area. You have been assigned to test the hypothesis that the average number of days that a home is on the market differs between these three real estate companies. It is believed that the selling price of the home could be an effective blocking factor for this test. These data can also be found in the Excel file housing market.xlsx.

Company Selling Price Century 21 Re/Max Weichert Under $300,000 37 18 86

$300,000 to under $400,000 41 44 71

$400,000 to under $500,000 46 63 59

$500,000 to under $600,000 38 67 72

a. Perform a randomized block ANOVA using a = 0.05 to test if a difference exists in the number of days a home is on the market between these three companies. Also, perform any other procedures that are necessary to complete this analysis.

b. If appropriate, perform a multiple comparison test to determine which main factor pairs are different using a = 0.05.

c. Verify your results with Excel.

AppendixLO1