Question

Given below are seven observations collected in a regression study on two variables, x (independent variable) and y (dependent variable). Use Excel to develop a scatter diagram and to compute the least squares estimated regression equation and the coefficient of determination.

xy
212
39
68
77
86
75
92


Shown below is a portion of a computer output for a regression analysis relating y (dependent variable) and x (independent variable).
ANOVA



dfSS
Regression150.58
Residual1355.42
Total14106.00





CoefficientsStandard Errort Stat
Intercept16.1561.42
Variable x-0.9030.26
a. Perform a t test and determine whether or not yand xare related. Use = 0.05.
b. Compute the coefficient of determination and fully interpret the meaning. Be very specific.

Answer

This answer is hidden. It contains 107 characters.