Share
Explore BrainMass

Multiple regression analysis with Excel

Do a multiple regression analysis for the following data in Excel where Selling Price is the dependent variable. Paste the results into a Word document. Below the output, write your hypotheses, decision and conclusion. Then highlight or circle the adjusted R2, the regression equation (or coefficients in Excel), the standard error of estimate and the p-value for the F-test. Thank you.

selling price size in 1000s sq ft # of bedrooms # of bathrooms
in $1000s

48.5 1.1 3 1
55 1.01 3 2
68 1.45 3 2
17.5 0.4 1 1
19.6 1.28 3 1
24.5 0.74 3 1
34.8 0.78 2 1
32 0.97 3 1
28 0.84 3 1
49.9 1.08 2 2
59.9 0.99 2 1
61.5 1.01 3 2
60 1.34 3 2
65.9 1.22 3 1
67.9 1.28 3 2
68.9 1.29 3 2
69.9 1.52 3 2
70.5 1.25 3 2
76 1.66 3 2
81.8 1.33 3 2
84.5 1.34 3 2
83.5 1.4 3 2
86 1.15 2 2
86.9 1.58 3 2
86.9 1.58 3 2
86.9 1.58 3 2
87.9 1.71 3 2
88.1 2.1 3 2
85.9 1.27 3 2
89.5 1.34 3 2
87.4 1.25 3 2
87.9 1.68 3 2
88 1.55 3 2
90 1.55 3 2
96 1.36 3 2
99.9 1.51 3 2
95.5 1.54 3 2
98.5 1.51 3 2

Solution Summary

The solution provides Multiple regression analysis with Excel

$2.19