Given Below Are Seven Observations Collected in a Regression Study $95 \%$

Essay

Given below are seven observations collected in a regression study on two variables, x (independent variable) and y (dependent variable). Use Excel to a. Compute a $95 \%$ confidence interval for $E ( y )$ when $x = 5$ .
b. Compute a $95 \%$ prediction interval for $y$ when $x = 5$ .
$\begin{array}{ll}x & y \\\hline 2 & 12 \\3 & 9 \\6 & 8 \\7 & 7 \\8 & 6 \\7 & 5 \\9 & 2\end{array}$