Use the values below. Compute beta-0-hat and beta-1-hat and complete the excel o

Question

Use the values below. Compute beta-0-hat and beta-1-hat and complete the excel output below. Note that the standard error of the coefficients are given.   

X

y

-1

0

-1

2

0

2

1

2

1

4

_____Regression_Statistics_______

Multiple R                   ___________

R Square                     ___________

Adjusted R Square      _XXXXXXX

Standard Error            ___________

Observations               ___________

ANOVA______________________________________________

___________df_______SS______MS______F____Significance F

Regression    ____       _____        _____     _XXX_    _XXXXX__

Residual       ____       _____        _____

Total             ____       _____

_____________Coeffic._Std Err_t Stat_P-val_Low_95%_Up_95%

Intercept          _____   _0.5__ _____ _____ ______     _______

X Variable 1      _____   _0.5_   _____ _____ ______     ______

X

y

-1

0

-1

2

0

2

1

2

1

4

Explanation / Answer

From the above table of regression output

Beta-0-hat = 2.00

Beta-1-hat = 1.00

SUMMARY OUTPUT Regression Statistics Multiple R 0.707107 R Square 0.5 Adjusted R Square 0.333333 Standard Error 1.154701 Observations 5 ANOVA df SS MS F Significance F Regression 1 4 4 3 0.18169 Residual 3 4 1.333333 Total 4 8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 2 0.516398 3.872983 0.030466 0.356592 3.643408 0.356591795 3.643408205 X 1 0.57735 1.732051 0.18169 -0.83739 2.837386 -0.837386231 2.837386231

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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