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

  1. 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
  2. Using Model #1, test the Hypothesis that the Price of Houses changes significantly if the house has a Fireplace at .025 Level of Significance.
  3. 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
  4. 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?
  5. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!