Share
Explore BrainMass

Regression Analysis for price of homes

House # Price Total Square Feet
1 $202,500 610
2 $199,500 600
3 $200,750 620
4 $185,999 590
5 $250,000 675
6 $245,500 650
7 $289,990 718
8 $212,500 625
9 $300,000 800
10 $299,000 790
11 $315,000 830
12 $310,900 820
13 $255,000 650
14 $275,000 700
15 $269,990 695

Refer to your Excel regression report. Look for the ANOVA report. Identify this F ratio. What does the F ratio tell you about the fit of the regression equation to the sample points? What does it suggest?

Solution Preview

Please see the attachments.

regression equation
House # Price Total Square Feet
1 $202,500 610
2 $199,500 600
3 $200,750 620
4 $185,999 590
5 $250,000 675
6 $245,500 ...

Solution Summary

The solution provides step-by-step method for the calculation of regression model for home price. Formula for the calculation and Interpretations of the results are also included.

$2.19