Explore BrainMass
Share

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

© BrainMass Inc. brainmass.com August 17, 2018, 1:11 pm ad1c9bdddf

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