Share
Explore BrainMass

Predicting Number of Touchdowns

Q2 Can you predict the number of touchdowns from the following variables: attempts, yards, and yards per game?
a Develop a correlation matrix for the 3 predictor variables, do you suspect multicolinarity?
b What is your multiple regression equation, is it significant?
c Predict the number of touchdowns for a back with 200 attempts, 600 yards, and 57 yards per game. Interpret your data analysis.

Player Attempts Yards Yards per game Touchdowns
Jamal Lewis 387 2066 129.1 14
Clinton Portis 290 1591 122.4 14
Ahman Green 355 1883 117.7 15
Stephen Davis 318 1444 103.1 8
LaDainian Tomlinson 313 1645 102.8 13
Deuce McAllister 351 1641 102.6 8
Fred Taylor 345 1572 98.2 6
Edgerrin James 310 1259 96.8 11
Travis Henry 331 1356 90.4 10
Shaun Alexander 326 1435 89.7 14
Priest Holmes 320 1420 88.8 27
Ricky Williams 392 1372 85.8 9
Curtis Martin 323 1308 81.8 2
William Green 142 559 79.9 1
Anthony Thomas 244 1024 78.8 6
Tiki Barber 278 1216 76 2
Marshall Faulk 209 818 74.4 10
Rudi Johnson 215 957 73.6 9
Domanick Davis 238 1031 73.6 8
Eddie George 312 1031 64.4 5
Kevan Barlow 201 1024 64 6
Garrison Hearst 178 768 64 3
Warrick Dunn 125 672 61.1 3
Troy Hambrick 275 972 60.8 5
Michael Bennett 90 447 55.9 1
Trung Canidate 142 600 54.5 1
Marcel Shipp 228 830 51.9 0
Jerome Bettis 246 811 50.7 7
Antowain Smith 182 642 49.4 3
T.J. Duckett 197 779 48.7 11
Michael Pittman 187 751 46.9 0
Moe Williams 174 745 46.6 5
Tyrone Wheatley 159 678 45.2 4
Kevin Faulk 178 638 42.5 0
Corey Dillon 138 541 41.6 2
Lee Suggs 56 289 41.3 2
Brian Westbrook 117 613 40.9 7
Charlie Garner 120 553 39.5 3
Thomas Jones 137 627 39.2 3
Onterrio Smith 107 579 38.6 5
Shawn Bryson 158 606 37.9 3
Correll Buckhalter 126 542 36.1 8
Adrian Murrell 28 107 35.7 0
Quentin Griffin 94 345 34.5 0
Artose Pinner 39 99 33 0
James Jackson 102 382 31.8 3
Stacey Mack 93 253 31.6 4
DeShaun Foster 113 429 30.6 0
J.R. Redmond 9 30 30 0
Lamar Gordon 71 298 29.8 1

Solution Summary

This solution conducts a regression analysis on the number of touchdowns scored by a specific player. A correlation matrix is created, and the multiple regression equation is determined to predict the number of touchdowns for a back with 200 attempts, 600 yards and 57 yards per game. All steps are shown clearly in an Excel file.

\$2.19