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}$$

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

Quizplus · Accepted Answer

The Answer of 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}$$

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

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}$