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 itspredictors.
.png)
SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.814 0.663 0.636 51.761 28 ANOVA df Regression Residual Total 131567.02 66979.65 198546.68 MS 65783.51 2679.19 Significance F 0.0000013 24.55 25 27 t Stat 3.01 2.11 3.90 P-value 0.0059 0.0448 0.0006 Coefficients Intercept 203.3937 1.1151 -2.2115 Standard Error 67.518 0.528 0.567
Step by Step Solution
3.27 Rating (171 Votes )
There are 3 Steps involved in it
There are two predictors in this model The equation of the regression model is 2033937 ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
243-M-S-L-R (419).docx
120 KBs Word File
