Question: Model Summary - Model #2 Model R R Square Adjusted R Square Std. Error of the Estimate 1 .887 a .788 .775 12539.1213 a. Predictors:
Model Summary - Model #2 Model R R Square Adjusted R Square Std. Error of the Estimate 1 .887a .788 .775 12539.1213 a. Predictors: (Constant), Number of Bedrooms, House is Located in Apple Valley, House Has Electrical Heating System, House Has a Basement, Living Space in Square Feet, Age of House in Years
Model #2 Coefficients | |||||||
|---|---|---|---|---|---|---|---|
Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | |||
B | Std. Error | Beta | |||||
1 | (Constant) | 8410.525 | 7956.984 | 1.057 | .293 | ||
Living Space in Square Feet | 42.970 | 3.076 | .724 | 13.969 | .000 | ||
Age of House in Years | -1081.054 | 298.836 | -.190 | -3.618 | .000 | ||
House is Located in Apple Valley | 6089.639 | 2616.756 | .113 | 2.327 | .022 | ||
House Has a Basement | 12176.424 | 3469.437 | .169 | 3.510 | .001 | ||
House Has Electrical Heating System | -13879.551 | 6514.348 | -.100 | -2.131 | .036 | ||
Number of Bedrooms | 3692.104 | 2004.131 | .095 | 1.842 | .068 | ||
a. Dependent Variable: Actual Selling Price of House |
- Using Model #2, test the Hypothesis that the Price of Houses changes significantly and in what direction if the House has Electrical Heating at .025 Level of Significance
- Using Model #1, test the Hypothesis that the Price of Houses changes significantly if the house has a Fireplace at .025 Level of Significance.
- Using the results of Model #2, what would you predict to be the Price of a House that is 15 years old, no basement, in Eastville, Gas Type Heat, 3 Bedrooms and 1,500 Square Feet
- Using the results of Model #2, what would you predict to be the Price of a House that is 18 years old, a basement, in Apple Valley, Electrical Heat, 2 Bedrooms and 1800 Square Feet?
- What will be the Price of the house in (g) if the house is located in East Ville?
6. Why do think that Electrical Heating Systems lower the price of Houses?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
