Shown below is a portion of an Excel output for regression analysis relating Y (dependent

variable) and X (independent variable).

ANOVA df SS

Regression 1 3328.312

Residual 8 10539.654

Total 9 13867.966

Coefficient

s Standard Error t Stat P-value

Intercept 241.76 83.280 1.689 0.030

X 148.72 38.312 1.283 0.055

1. What is the estimated regression equation that relates y to x? (2 Points)

2. Is the regression relationship significant? Use a p-value and alpha = 0.05. (2 Points)

3. What is the estimated value of y if x = 5.5? (2 Points)

4. Compute the value of the coefficient of determination and interpret its meaning. Be very

specific. (2 Points)