Please show an Excel Regression model of the information presented below. Includ

Question

Please show an Excel Regression model of the information presented below. Include the formula in the cell for any figure.

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.928771

R Square

0.862616

Adjusted R Square

0.835139

Standard Error

4.274127

Observations

7

ANOVA

df

SS

MS

F

Significance F

Regression

1

573.5163

573.5163

31.3943

0.002502

Residual

5

91.34083

18.26817

Total

6

664.8571

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

14.13121

12.72568

1.110448

0.317333

-18.5812

46.84362

-18.5812

46.84362

Initial Survey Score

0.856542

0.15287

5.603062

0.002502

0.463576

1.249508

0.463576

1.249508

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.928771

R Square

0.862616

Adjusted R Square

0.835139

Standard Error

4.274127

Observations

7

Explanation / Answer

It is regression analysis output generated by excel:

The regression model can be found directly from the last table (from column coefficients).

The regression model is:

y' = 14.13121 + 0.856542x

Here y shows the dependent variable.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.