Explore BrainMass

# Multiple regression analysis with Excel

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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