Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Multiple Regression for Price Multiple R R-Square Adjusted R-square Std. Err. of Estimate Rows Ignored Outliers Summary 0.9113 0.8304 0.8205 53965.50872 0 0 Degrees of
Multiple Regression for Price | Multiple R | R-Square | Adjusted R-square | Std. Err. of Estimate | Rows Ignored | Outliers |
Summary | ||||||
0.9113 | 0.8304 | 0.8205 | 53965.50872 | 0 | 0 | |
Degrees of Freedom | Sum of Squares | Mean of Squares | F | p-Value | ||
ANOVA Table | ||||||
Explained | 7 | 1.71095E+12 | 2.44422E+11 | 83.92813198 | < 0.0001 | |
Unexplained | 120 | 3.49473E+11 | 2912276131 | |||
Coefficient | Standard Error | t-Value | p-Value | Confidence Interval 95% | ||
Regression Table | Lower | Upper | ||||
Constant | -1604.041946 | 47963.30572 | -0.033443107 | 0.9734 | -96568.04927 | 93359.96538 |
SqFt | 271.5919875 | 30.6792227 | 8.852635875 | < 0.0001 | 210.8492617 | 332.3347133 |
Bedrooms | 23589.40397 | 8471.084619 | 2.784697006 | 0.0062 | 6817.245973 | 40361.56198 |
Bathrooms | 39205.00555 | 11474.26469 | 3.416777164 | 0.0009 | 16486.76002 | 61923.25108 |
Offers | -42948.45394 | 5861.934546 | -7.326668971 | < 0.0001 | -54554.67638 | -31342.23151 |
new brick | 77565.43703 | 10521.65639 | 7.371979673 | < 0.0001 | 56733.28963 | 98397.58442 |
Neighborhood (W) | -8105.238284 | 13122.45838 | -0.617661573 | 0.5380 | -34086.79261 | 17876.31605 |
Neighborhood (E) | 75035.79121 | 16823.59788 | 4.460151256 | < 0.0001 | 41726.23824 | 108345.3442 |
2. According to Model 1 estimated above, by how much does the average price in the East differs from the average price of a similar house in the North?
3. According to Model 1, by how much does the average price in the West differs from the average price of a similar house in the East?
4. Define the "brick premium" as the average amount by which the price of a brick house exceeds the price of a similar house made without brick.
According to Model 1, what is the brick premium in Springfield?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started