Status: A multiple regression analysis produced the following output from Excel.

Question

Status: A multiple regression analysis produced the following output from Excel. SUMMARY OUTPUT Regression Stotistics Multiple R RSquare Adjusted R Squa 0952287472 0.978724022 0.957900711 Standard Error 67.67055418 Observations 18 ANOVA df MS Significance F Regression Residual Total 562918.941 781459.5 170.6503 68689.55855 4579.304 4.80907E-11 15 17 1631608.5 Intercept x1 X2 Coefficients Stondard ErrortStat P-value 1959.709718 0.469657287 -2.163344882 0.278361425 -7.77171 1.236-06 306.4905312 6.39403 1.21E-05 0.264557168 -1.77526 0.096144 The overall proportion of variation of y accounted by x1 and x2 is 0.9787 0.9579 0.9523 67.671 Click Save and Submit to save and submit. Click Save All Answers to save all answers. pl (1) docx Manufacturing (1) x sx

Explanation / Answer

Answer - 1: Proportion of variation of y accounted from x1 and x2 = R - square = 0.9579; Option B

Answer - 2: Slopes: 0.0732, -0.0323, -0.0039; Option D

Answer - 3: Option D

Answer - 4: Option B; F test

Answer - 5: Option A

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---