Question: Explain why this regression model is significant with the summary output use regression concepts UTILITY =Monthly Utility Cost COST06 =Housing Cost at 6 percent Interest

Explain why this regression model is significant with the summary output use regression concepts

UTILITY =Monthly Utility Cost

COST06 =Housing Cost at 6 percent Interest

ABLMED =Median Income Adjusted for # of Bedrooms

BEDRMS =# of bedrooms in unit

UTILITY=?0+?1*X1+?2*X2 +?3*X3+?

UTILITY=?0+?1*COST06+?2*ABLMED +?3*BEDRMS+?

Below is the Summary OutPut from Excel

SUMMARY OUTPUT

Regression Statistics

Multiple R 0.589079

R Square 0.347014

Adjusted R Square 0.346984

Standard Error 105.1893

Observations 64535

 Explain why this regression model is significant with the summary output

ANOVA MS F Significance F Regression 3.790+08 1.268+08 11431.18 Residual 64531 7.140+08 11064.79 Total 64534 1 090+09 Coefficients Standard Error t Stat P-valve Lower 9595 Upper 95% Lower 95_09% Upper 95.0% Intercept -10.0181 1 827855 -5.48082 4.25E-08 -13.6007 -6.43555 -13.6007 -6.43555 COSTOG 0.01641 0.000274 59.88312 D.015873 0.016947 D.015873 D.016947 ABLMED 0.000406 3.47E-05 11.70137 1.35E-31 D.000338 0.000474 D.00 033E D.000474 BEDRMS 52.92576 0.49346 107.2544 51.95858 53.89294 51 95858 53.89294

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!