Question

mouse of Representatives. OW) UI city 12-16: College Football Players (cont Below is the open us is the opening day roster for the 1999 Cal Poly for class class SR SR class # # 48 50 51 Name p osit weight Joe Martinez LB 225 Jesse Van Horn 1B Harrison Stewart LB FR DB 85 195 210 270 RB 215 DB John Lloyd Javier Ortiz Tim Collins Juan Gonzalez Delon Craft Zak Repeka Eric Wicks Travis Wheat Matt Merritt Craig Knowles Dan Loney Sal Rivas 59 Name p osit weight Troy Henry WR 175 David Kellogg WR 175 Chris Jone WR 50 Vaugn Jarrett 5 Kassim Osgood 190 Raj Thompson Spencer Faddis DB 190 Kurt Rubin 195 Mike Davies DB 170 10 Dave Woods 205 11 Andy Jepson QB 190 Jamar isson DB 180 16 Kevin Cooper QB 185 17 Adam Herzing WR 195 18 Jason Brennan WR 19 Robbie Bogdanovich LB 215 0 Craig Young RB 22 David Richardson Aaron Alston Ameer Ross Mike Chavis WR Vic Greco 235 Jeff Shaw - Dominic Washington RB 53 54 FR 55 SO 57 FR 58 FR SR 61 FR63 SO64 SO 66 JR 68 FR 70 SR 71 FR 72 FR 73 14 의 의의의 의의의 의의 이의 의의의의 의의의의 이 OL 26550 300 SR 175 190 DB Kris Wicks Dane Smith Steve Prejean Greg Mendonsa Ryan Pittman Dan Leahy Dustin Kroeker Chad McEwan OL 295FR ou 31050 175 OL os SR DB 160 So 74 FR 175 210 JR76 JR78 ngton RB205FR 79 David dunod

Answer 1

We will plot the trend line using MS-Excel:

For doing that follow these steps:

• Feed all the data in the worksheet
• Select both the columns i.e of Jersey Number and weights
• Draw the scatter plot
• then customize it
• Under the layout, tab select the trendline and it's done.

-------------------------------------------------------------------------------------------

a.]

1 175 2. 175 150 4 185 5 190 6 215 ww 7 190 350 195 9 170 300 10 205 11 190 250 14 180 16 185 200 17 195 18 175 150 19 215 20 190 100 y 0.850x181.0 R2 - 0.357 22 180 23 195 50 24 160 25 175 0 26 210 0 40 60 80 100 120 28 235 29 205 Jersey Number 30 215 31 195 32 195 Weights 20

===========================================================================

b.]

So, in the trend line plot we can clearly see that the regression line equation is:

$Y~=~0.850X+181.0$

where, X represents the Jersey Number and Y with Weights.

We have to predict the weight of the player wearing jersey number 50:

$Y~=~0.850*50+181.0~=~223.5$

============================================================================

e.]

On seeing over the trend line we can see that the trend line is in positive deviation as Jersey number is increasing the weights are also in the increasing direction in the long run, also we know that the trend line doesn't give us exact value it only estimates the values or approx values. We are getting a correlation of 0.357 which is not quite good but in rare case it can be said that it is some kind of use but not have highly efficiency.

============================================================================================