Share
Explore BrainMass

Multipe regression equation for size and selling price of suburban community homes

A real estate association in a suburban community would like to study the relationship between the size of a single-family house (as measured by number of rooms) and the selling price of the house (in thousands of dollars). Two different neighborhoods are included in the study, one on the east side of the community (=0) and the other on the west side (=1). A random sample of 20 houses was selected with the results given at left.

Q-6a. State the multiple regression equation that predicts the selling price based on the number of rooms in the neighborhood.

Q-6b. Interpret the regression coefficients.

Q-6c. Predict the selling price for a house with nine rooms that is located in an East-side neighborhood.

Q-6d. Compute and interpret the adjusted r2.

Price Rooms Neighborhood
309.6 7 0
307.4 8 0
340.3 9 0
346.5 12 0
298.2 6 0
337.8 9 0
324.1 10 0
313.2 8 0
327.8 9 0
325.3 8 0
308.5 6 1
381.3 13 1
337.4 10 1
346.2 10 1
342.4 9 1
323.7 8 1
329.6 8 1
343.6 9 1
360.7 11 1
348.3 9 1.

Solution Preview

Please find the solution/explanation attached herewith.

Price Rooms Neighborhood
309.6 7 0
307.4 8 0
340.3 9 0
346.5 12 0
298.2 6 0
337.8 9 0
324.1 10 0
313.2 8 0
327.8 9 0
325.3 8 0
308.5 6 1
381.3 13 1
337.4 10 1
346.2 10 1
342.4 9 1
323.7 8 1
329.6 8 1
343.6 9 1
360.7 11 1
348.3 9 1

A real estate Association in a suburban community would like to study the relationship between the size of a single-family house (as measured by number of rooms) and the selling price of the house (in thousands of dollars). Two different neighborhoods are included in the study, one on the ...

Solution Summary

This solution provides the regression analysis using ANOVA. The Excel output is discussed in the attached Word file.

$2.19