Question: CHALLENGE ACTIVITY 8 . 2 . 1 : Optimizing model fits. ( square ) 5 9 4 2 9 6 . 4

CHALLENGE
ACTIVITY
8.2.1: Optimizing model fits.
\(\square \)
594296.4727760.qx3zqy7
Jump to level 1
Calculate the value of the sum of squared residual as well as a formula including a cell list.
\begin{tabular}{|c|c|c|c|c|c|}
\hline & A & B & C & D & E \\
\hline \(\mathbf{1}\) & x data & y data & y model & r & \(\mathrm{r}^{\wedge}2\)\\
\hline \(\mathbf{2}\) & \(\mathbf{1}\) & 12 & 6 & & \\
\hline \(\mathbf{3}\) & 3 & 28 & 12 & & \\
\hline \(\mathbf{4}\) & 5 & 24 & 18 & & \\
\hline \(\mathbf{5}\) & 7 & 48 & 36 & & \\
\hline \(\mathbf{6}\) & 9 & 60 & 55 & & \\
\hline \(\mathbf{7}\) & 11 & 48 & 36 & & \\
\hline \(\mathbf{8}\) & 13 & 49 & 77 & & \\
\hline \(\mathbf{9}\) & 15 & 56 & 104 & & \\
\hline \(\mathbf{10}\) & 17 & 126 & 54 & & \\
\hline \hline
\end{tabular}
Copy sheet
ssr formula: \(=\) SUM(E2:E10)
ssr \(=3297\)
Next
Feedback?
CHALLENGE ACTIVITY 8 . 2 . 1 : Optimizing model

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!