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

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
Get step-by-step solutions from verified subject matter experts
