The table below shows the data for 5 perch caught in a lake in Finland, (note: p

Question

The table below shows the data for 5 perch caught in a lake in Finland, (note: perch is a type of freshwater fish) For all calculations--show the formulas with values used. Produce a scatterplot of the data, with the Weight vs. Length. Draw a rough linear regression line by eyeballing. Produce a scatterplot of the data, with the Weight vs. Width. Draw a rough linear regression line by eyeballing. Which relationship Weight vs. Length OR Weight vs. Width appears to be stronger? Why do you say this? Compute the mean and standard deviation of Weight. Calculate the covariance of the Weight and Length. Calculate the correlation between the Weight and Length. What is the r^2 for Weight and Length? Given that r^2 = 0.5742 for Weight and Width, what is the covariance for Weight and Width?

Explanation / Answer

d) Command:

=AVERAGE(B2:B6)

=STDEVP(B2:B6)

a) Command: Select the column of width and length-> Insert-> scatter plot->scatter with smooth lines-> chart layouts-> select 7th layout that shows regression equation and r^2 on graph.

b)

Follows as above just put width column instead of length.

Command :

=COVAR(B2:B6,C2:C6)

=CORREL(B2:B6,C2:C6)

Follows the same command for covariance for weight and width just place the column of width in place of length.

Perch Weight Length Width 1 100 19.2 3.3 2 110 22.5 3.6 3 120 23.5 3.5 4 150 24 3.6 5 145 25.5 3.8 mean 125 std. dev 19.49359

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.