Share
Explore BrainMass

Multiple Regression Analysis

Run a multiple regression equation and interpret the coefficient results to determine that these independent variables impact the sale price of a home.

Model is:

HOUSE PRICE ESTIMATE = BEDROOMS + SQUARE FOOTAGE + GARAGE + BATHS

DATA SETS

Variables

X1 = Selling price in $000
X2 = Number of bedrooms
X3= Size of the home in square feet
X4= Size of the garage in square feet
X5= Number of bathrooms

30 homes sold

PRICE BEDROOMS SQUARE FOOTAGE GARAGE BATHS
285 4 2799 618 3.5
277.4 3 2544 576 3
266.5 3 2544 576 3
178.6 4 1797 431 2.5
170.6 4 1797 431 2.5
290 5 3121 561 3
197.8 4 1809 431 3
264.5 3 2544 576 3
180.5 4 1809 431 2.5
251.4 4 2799 618 3.5
265.5 4 2799 618 3.5
176.9 3 2136 431 3
264.5 3 2544 576 3
188.9 4 2136 431 3
260.4 3 2544 576 3
261 3 2544 576 3
183.5 3 2136 431 3
321.2 5 3121 561 3
380.2 4 3909 604 3.5
168.1 4 1797 431 2.5
251.6 3 2544 576 3
167.3 4 1797 431 2.5
258.6 4 2799 618 3.5
172.2 4 1809 431 3
246 3 2544 576 3
254.8 3 2544 576 3
200.3 3 2136 431 3
173.9 4 1797 431 2.5
195.7 4 1809 431 3
164.8 3 1617 437 2.5

Attachments

Solution Summary

The solution provides step by step method for the calculation of multiple regression analysis. Formula for the calculation and Interpretations of the results are also included.

$2.19