Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

16. Consider the following Excel regression output (at following Excel regression output (at 95% confidence) SUMMARY OUTPUT Regression Statistics Multiple R 0 .819689678 R Square

image text in transcribed
16. Consider the following Excel regression output (at following Excel regression output (at 95% confidence) SUMMARY OUTPUT Regression Statistics Multiple R 0 .819689678 R Square 0.671891168 Adjusted R Square 0.64758681 Standard Error 3.815100634 Observations ANOVA 30 Significance F 2.92578E-07 Regression Residual Total 29 SS MS 804.742193 402.3710965 27.64488 392.984807 14.55499285 1197.727 Standard Error Staf P-value 2 .27395932 7.33003001 6.95E-08 0.068578601 -5.802341513 3.57E-06 0.029497293 4.540255365 0.000105 Intercept Coefficients 16.66819005 -0.397916465 0.133925245 a. Write the estimated multiple linear regression equation. b. Classify the goodness of fit for this regression equation (circle a response and explain); WEAK MODERATE STRONG because c. Is the model used statistically significant? Pick a response and explain. Yes No because d. Which of the independent variables are statistically significant, if any

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_2

Step: 3

blur-text-image_3

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

Capital Markets Institutions Instruments And Risk Management

Authors: Frank J. Fabozzi

5th Edition

0262029480, 9780262029483

More Books

Students also viewed these Finance questions

Question

Explain the benefits of a health and wellness strategy

Answered: 1 week ago

Question

Describe the components of a workplace wellness programme

Answered: 1 week ago