Use the data above, find the best predictor of weight.Perform the following regr

Question

Use the data above, find the best predictor of weight.Perform the following regression analysis a) Weight versus length and width b) Weight versus length and squared length c) Weight versus length and squared width Plot weight as a function of length, and weight as a function of width. Then discuss the results, using the output statistics to justify which is the best fit.
Minitab.mtw C1 C2 03 C4 C5 weight length width 5.9 2 100.0 3 110.0 4 120.0 150.0 145.0 7 300.0 300.0 685.0 10 650.0 11 820.0 12 1000.0 8.8 19.2 22.5 23.5 24.0 25.5 28.7 30.1 39.0 414 42.5 46.6 14 1.4 3.3 3.6 3.5 3.6 3.8 5.1 4.6 6.9 6.0 6 14 6.6 7.6

Explanation / Answer

I will perform all the operations given above in the MS-EXCEL using the data analysis add-in. If you don have data analysis add-in go through the following steps.

File-> Options -> Add-Ins -> Analysis Tool pak ->Go -> Check mark on Analysis ToolPak ->Ok

Now in the Data Section you will see the Data Analysis Plugin which you can utilize to carry out regression.

Please find the original file at the link below on which I have carried out the regression, to match your answers.

https://www.dropbox.com/s/d9naiyoj7ic4rlv/Perch.xlsx?dl=0

The R-squared value is closest to 1 in the (b) part. Thus length and length squared are the best predictors of the weight.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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