Question: Need help with the following question, mostly E-H. Giving the selling price of the dependent variable and house size, house age and are independent variables

Need help with the following question, mostly E-H.

Giving the selling price of the dependent variable and house size, house age and are independent variables please fill in the table and answer the following questions (a-h). (a = 0.05)

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.9571

R Square

_____

Adjusted R Square

0.8932

Standard Error

6.8940

Observations

_____

ANOVA

df

SS

MS

F

Significance F

Regression

3

5707.4385

_____

_____

3.27814E-06

Residual

11

_____

47.5270

Total

_____

6230.2360

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

-16.0580

19.0710

-0.8420

0.4177

-58.0331

25.9171

_____

25.9171

House Size

4.1462

0.7512

5.5195

0.0002

2.4928

5.7995

2.4928

_____

House Age

-0.2361

0.8812

-0.2679

0.7937

-2.1756

1.7035

_____

1.7035

Area

4.8309

0.9011

5.3612

0.0002

2.8476

6.8141

2.8476

_____

a) Write and interpret the estimated regression equation

b) What is the number of observations

c) What percent of the variation is explained by the regression equation, please explain.

d) What is the standard error of regression, please explain.?

e) What is the variance of the slope coefficient of House size?

f) Conduct a global test of hypothesis to determine if any of the regression coefficients are not zero.

g) Conduct a test of hypothesis for each of the independent variables. Which one you would eliminate and why?

h) Interpret and show that you understand this computer printout. (Significant weight will be given to this question)

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 Mathematics Questions!