Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus

Authors: Michael Sullivan

9th edition

321716835, 321716833, 978-0321716835

More Books

Students also viewed these Mathematics questions