Managerial Economics: Applications, Strategy and Tactics 12th Edition by James McGuigan, Charles Moyer, Frederick Harris

Exercise 3

In a study of housing demand, the county assessor is interested in developing a regression model to estimate the market value (i.e., selling price) of residential property within his jurisdiction. The assessor feels that the most important variable affecting selling price (measured in thousands of dollars) is the size of house (measured in hundreds of square feet). He randomly selected 15 houses and measured both the selling price and size, as shown in the following table.
a. Plot the data.
b. Determine the estimated regression line. Give an economic interpretation of the estimated slope (b) coefficient.
c. Determine if size is a statistically significant variable in estimating selling price.
d. Calculate the coefficient of determination.
e. Perform an F-test of the overall significance of the results.
f. Construct an approximate 95 percent prediction interval for the selling price of a house having an area (size) of 15 (hundred) square feet.