Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Study the Excel regression output that follows. How many predictors are there? What is the equation of the regression model? Using the key statistics discussed

Study the Excel regression output that follows. How many predictors are there? What is the equation of the regression model? Using the key statistics discussed in this chapter, discuss the strength of the model and its predictors.

Summary Output
Regression Statistics
Multiple R 0.814
R Square 0.663
Adjusted R Square 0.636
Standard Error 51.761
Observations 28
ANOVA
df SS MS F Significance F
Regression 2 131567.0243 65783.5121 24.55 0.0000013
Residual 25 66979.6543 2679.19
Total 27 198546.6786
Coefficients Standard Error t Stat P-value
Intercept 203.3937 67.5177 3.01 0.0059
X1 1.1151 0.5278 2.11 0.0448
X2 2.2115 0.5667 3.90 0.0006

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

Combinatorics And Graph Theory

Authors: John M Harris, Jeffry L Hirst, Michael J Mossinghoff

2nd Edition

0387797114, 9780387797113

More Books

Students also viewed these Mathematics questions