Given Below Are Seven Observations Collected in a Regression Study $$\begin{array} { l l } x & y \\\hline 2 & 12 \\3 & 9 \\6 & 8 \\7 & 7 \\8 & 6 \\7 & 5 \\9 & 2\end{array}$$

Essay

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. $$\begin{array} { l l } x & y \\\hline 2 & 12 \\3 & 9 \\6 & 8 \\7 & 7 \\8 & 6 \\7 & 5 \\9 & 2\end{array}$$