TABLE 15-3 In Hawaii, condemnation proceedings are under way to enable private citizens to own the property that their homes are built on. Until recently, only estates were permitted to own land, and homeowners leased the land from th estate. In order to comply with the new law, a large Hawaiian estate wants to use regression analysis to estimate the fair market value of the land. The following model was fit to data collected for n = 20 properties, 10 of which located near a cove. where Y = Sale price of property in thousands of dollars XI = Size of property in thousands of square feet X2= 1 if property located near cove, 0 if not Using the data collected for the 20 properties, the following partial output obtained from Microsoft Excel is shown: SUMMARY OUTPUT Regression Statistics Multiple R 0.985 R Square 0.970 Standard Error 9.5 Observations 20 ANOVA df SS MS F Signif F Regression 5 28324 5664 62.2 0.0001 Residual 14 1279 91

TABLE 15-3 In Hawaii, condemnation proceedings are under way to enable private citizens to own the property that their homes are built on. Until recently, only estates were permitted to own land, and homeowners leased the land from the estate. In order to comply with the new law, a large Hawaiian estate wants to use regression analysis to estimate the fair market value of the land. The following model was fit to data collected for n = 20 properties, 10 of which are located near a cove. where Y = Sale price of property in thousands of dollars X1 = Size of property in thousands of square feet X2 = 1 if property located near cove, 0 if not Using the data collected for the 20 properties, the following partial output obtained from Microsoft Excel is shown: SUMMARY OUTPUT Regression Statistics Multiple R 0.987 R Square 0..974 Standard Error 9.5 Observations 20 ANOVA df SS MS F Signif F Regression 5 28324 5664 62.2 0.0001 Residual 14 1279 91 Total 19 29063 Intercept Size Cove Size*Cove SizeSq…

Interpret the following graphs for multiple linear regression and comment on the validity of model assumptions

Suppose a researcher collects data on houses that have been sold in a particular neighbourhood over the past year, and obtains the regressions results in the table shown below. A family purchases a 2000 square foot home and plans to make extensions totalling 500 square feet. The house currently has a pool, and a real estate agent has reported that the house is in excellent condition. However, the house does not have a view, and this will not change as a result of the extensions. According to the results in column (1), what is the expected DOLLAR increase in the price of the home due to the planned extensions?