Question: 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

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!