For parts (a), (b), and (c), use the 2009-11 data to build the indicated models. The dependent (y) variable is PTS. (b)

[answerhappygod]

For parts (a), (b), and (c), use the
2009-11 data to build the indicated models. The dependent (y)
variable is
PTS.
(b) Use your work from part (a), which
model maximizes adjusted R2?
(c) Find the following regression
models: (i) use TA, PAVG, and TO, (ii) Find the regression model
using TA, PAVG, and FD, (iii) Find the regression model using TA,
TO, and FD, (iv) Find the regression model using PAVG, TO, and
DF.
(d) For each of the models found in
parts (a), (b), and (c), predict PTS in 2012 and calculate the root
mean square error. Which model is preferred?

For Parts A B And C Use The 2009 11 Data To Build The Indicated Models The Dependent Y Variable Is Pts B 1 (118.79 KiB) Viewed 15 times

25 Х fx 24.8 А B C D E F G H Team Year PTS TA PAVG TO SCK RAVG FD Green Bay Packers 2011 35 2.375 9.3 0.875 2.5625 3.9 New Orleans Saints 2011 34.2 1 8.3 1.1875 1.5 4.9 New England Patric 2011 32.1 2.125 8.6 1.0625 2 4 Detroit Lions 2011 29.6 2.125 7.6 1.4375 2.25 4.3 San Diego Chargers 2011 25.4 1.3125 7.9 1.75 1.875 5.4 Carolina Panthers 2011 25.4 1.5 7.9 1.4375 2.1875 4.3 Atlanta Falcons 2011 25.1 1.8125 7.3 1.3125 1.625 4 Philadelphia Eagles 2011 1.5 7.7 2.375 2 5.1 New York Giants 2011 24.6 1.9375 8.4 1.5 1.75 3.5 1 San Francisco 49ers 2011 23.8 2.375 7.1 0.625 2.75 4.5 2 Houston Texans 2011 23.8 1.6875 7.9 1.25 2.0625 4.1 3 Baltimore Ravens 2011 23.6 1.625 6.7 1.5 2.0625 4.3 4 New York Jets 2011 23.6 1.9375 6.5 2.125 2.5 3.8 5 Buffalo Bills 2011 23.3 1.9375 6.7 1.875 1.4375 4.9 6 Dallas Cowboys 2011 23.1 1.5 7.8 1.3125 2.4375 4.4 7 Oakland Raiders 2011 22.4 1.625 7.9 1.875 1.5625 4.5 8 Chicago Bears 2011 22.1 1.9375 721 1.8125 3.0625 4.4 9 Cincinnati Bengals 2011 21.5 1.375 1.375 1.5625 3.9 20 Minnesota Vikings 2011 21.3 1.4375 1.625 3.0625 5.2 99%B9%95%。 1 K COMP THRD 22.1 68.1 48.1 26 71.3 56.7 24.9 65.7 45.9 21.8 63.5 35.8 22.4 62.9 48.8 21.6 60.1 40.5 21.8 61.4 44.2 22.3 59.6 41.5 20.7 61 37.4 17.6 61.4 29.4 20.1 61.7 41.5 19.5 57.7 42.4 18.8 56.7 34.7 19.6 61.6 32.5 20.4 66 39.4 20.5 60.1 35.7 16.9 56.7 32.5 17.8 57.6 36.5 18.6 56.1 38.4
Font Alignment Number Q5 v Х ✓ fr B D E F G H L A 21 Miami Dolphins 22 Tennessee Titans 23 Pittsburgh Steelers 24 Seattle Seahawks 25 Arizona Cardinals 26 Denver Broncos 27 Washington Redski 28 Tampa Bay Buccane 9 Indianapolis Colts 0 Jacksonville Jaguar 1 Cleveland Browns 2 Kansas City Chiefs 3 St. Louis Rams New England Patric San Diego Chargers Philadelphia Eagles Indianapolis Colts Atlanta Falcons Oakland Raiders New York Giants 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 C 20.6 20.3 20.3 20.1 19.5 19.3 18 17.9 15.2 15.2 13.6 13.3 12.1 32.4 1.1875 1.4375 0.9375 1.9375 1.1875 1.125 1.3125 1.5 1.0625 1.75 1.25 1.625 1.125 2.375 1.375 2.125 1.3125 1.9375 1.5 2.4375 7.3 7 8 6.8 7.2 6.3 6.9 6.5 6 5.4 5.8 6.6 5.9 7.9 8.7 7.5 6.9 6.5 7.1 1.5625 1.375 1.75 1.4375 2 1.875 2.1875 2.5 1.8125 1.4375 1.1875 1.75 1.4375 0.625 1.8125 1.5625 1.5625 1.0625 1.625 2.625 3.25 1.5 2.625 3.125 3.375 2.625 2.5625 2 2.1875 2.75 2.4375 2.125 3.4375 1.5625 2.375 3.0625 1 1.4375 2.75 4.2 4.4 3.8 4 4.2 4.8 4 4.2 4.2 4 3.7 3.9 4.1 4.3 2011 17.9 17.6 21.3 16.6 17.9 17.9 19.5 17.3 16.1 15.7 17.4 17.3 16.7 20.9 22.3 20.1 22.9 22.1 19.1 20.7 59.7 60.4 63.3 58.7 55.8 50.6 58.5 62.1 56.6 51.2 56.1 59.8 K 33.3 36.7 45.9 33.8 32.2 30.8 37 36.9 34.6 33.6 38.7 36 53.2 28.1 2011 2011 2010 2010 2010 2010 2010 27.6 4 5.4 27.4 27.2 25.9 25.6 3.8 3.8 4.9 4.2 65.3 66 62 66.3 62.6 56.8 62.9 48.2 44.9 39.7 44.6 46.7 34.1 35.9 2010 2010 24.6 7.4 1
Q5 х D E H 1 L B 2010 2010 2010 7.3 7.6 8 2010 4.6 4.8 3.8 4 4.1 4.4 4.7 с 24.6 24.4 24.3 24 23.4 22.9 22.9 22.6 22.3 22.3 22.1 21.5 2010 2010 2010 2010 2010 2010 А 41 Dallas Cowboys 42 Houston Texans 43 Green Bay Packers 44 New Orleans Saints 45 Pittsburgh Steelers 46 Kansas City Chiefs 47 New York Jets 48 Detroit Lions 49 Tennessee Titans 50 Baltimore Ravens 51 Jacksonville Jaguar 52 Denver Broncos 53 Tampa Bay Buccane 54 Chicago Bears 55 Cincinnati Bengals 56 Seattle Seahawks 57 San Francisco 49ers 58 Washington Redski 59 St. Louis Rams 60 Arizona Cardinals 65.8 63.6 65.1 68.1 62.2 57.7 54.9 60.5 57.6 1.875 1.125 2 1.5625 2.1875 1.4375 1.875 1.8125 1.5625 1.6875 1.125 1.125 1.75 2.1875 1.625 1.375 1.375 1.6875 1.625 1.875 G 1.9375 2 2.375 1.625 2.6875 2 1.75 1.6875 1.6875 2.5 2.375 2.5 1.875 3.5 1.75 F 1.875 1.125 1.375 1.9375 1.125 0.9375 1.25 1.5625 1.5625 1.5 2.0625 1.6875 1.1875 1.9375 2.125 1.9375 1.4375 1.9375 1.3125 2.1875 7 8.1 6.7 6.5 6.3 6.9 7.4 7.2 7.4 7.2 7.3 6.8 6.5 7.2 4 3.8 4.3 4.7 3.9 2010 20.4 22.5 19.5 21.9 18.4 19.9 19.2 19 15.8 18.9 20.6 19.3 18 16.4 19.8 16.3 15.7 18.4 18.3 15.1 K 40.8 41.1 41.5 48.8 43.1 36.7 39.6 40.1 34.8 39 39.9 32.4 42.2 32.8 38.8 35.5 31.9 29.3 33.2 27.8 21.3 2010 2010 2010 2010 2010 20.9 20.1 19.4 is so i N 62.7 62 57.6 61.9 59.2 61.9 59.6 56.4 57.7 60 50.8 2.1875 2010 4.6 3.9 3.6 3.7 4.1 4.2 4.3 3.7 19.1 2.75 2010 2010 2010 18.9 18.1 18.1 ܚ ܢ ܗ ܤ 2.875 2.125 3.125 5.8
Q5 X fo с D E F I J к 1.375 2.4375 แสต์ 6.5 6.6 6.7 6.7 5.4 H 4.3 4.4 3.7 4 2.3125 1.9375 1.8125 2.3125 1.75 1.125 4.3 8.3 8 8.1 А 61 Buffalo Bills 62 Minnesota Vikings 63 Miami Dolphins 64 Cleveland Browns 65 Carolina Panthers 66 New Orleans Saints 67 Minnesota Vikings 68 Green Bay Packers 59 San Diego Chargers 70 Philadelphia Eagles 71 New England Patric 2 Indianapolis Colts 3 New York Giants 4 Baltimore Ravens 5 Houston Texans 6 Arizona Cardinals 7 Pittsburgh Steelers 8 Atlanta Falcons 9 Dallas Cowboys Miami Dolphins 8.7 7.9 B 2010 2010 2010 2010 2010 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 1.5625 1.1875 1.75 1.8125 2.4375 1.5 2.5 1.5 2.375 1.75 1.5625 1.5 17.7 17.6 17.1 16.9 12.3 31.9 29.4 28.8 28.4 26.8 26.7 26 25.1 24.4 24.3 23.4 23 22.7 22.6 22.5 G 2.125 2.25 2.375 2.25 3.125 1.25 2.125 3.1875 1.625 2.375 1.125 0.8125 2 2.25 1.5625 1.625 3.125 1.6875 2.125 2.125 09375 1 1.0625 1.4375 1.375 1.5 1.9375 1.375 1.75 7.7 16.4 18.1 18.8 16.6 14.1 21.8 21.4 20.9 20.6 18.1 23.3 21.2 20.2 20 21.3 19.8 20.7 20.6 20.9 20.8 18 4.5 4.1 4.3 3.3 4.3 4.1 3.5 4.1 4.7 3.5 4.1 4.2 4.2 57 60.4 60.1 61.9 52.9 69.5 68.2 64.6 65.1 60.6 65.9 66.9 62.4 62.9 67.3 66 65.5 58.2 63.1 60.7 56.9 37.9 34.6 40 37.1 30.4 44.7 44.8 47 44.4 36.2 43.7 49.2 42.9 41.6 40.2 36.3 39.4 42.1 40.6 2.25 7.7 7.8 7.1 8.1 7.1 8.4 6.5 8.2 6.2 SS 2 1.6875 1.8125 1.375 1.75 1.3125 1.3125 1.5625 1.5625 1.1875 1.8125 1 275 4.8 49 4.4 5.2 41.6 קרח
D B E F G A I H 6.5 6.6 5.2 4.5 4.3 6.2 6.5 6.9 4 18 17.5 14.9 16.4 19.1 18.1 18.4 16 18.8 55.2 81 Tennessee Titans 82 New York Jets 83 San Francisco 49ers 84 Chicago Bears 85 Denver Broncos 86 Carolina Panthers 87 Cincinnati Bengals 88 Kansas City Chiefs 89 Jacksonville Jaguar 20 Seattle Seahawks 31 Washington Redski 22 Detroit Lions 3 Buffalo Bills 4 Tampa Bay Buccane 5 Cleveland Browns 5 Oakland Raiders St. Louis Rams C 22.1 21.8 20.6 20.4 20.4 19.7 19.1 18.4 18.1 17.5 16.6 16.4 16.1 15.3 15.3 12.3 10.9 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 2009 1.6875 1.9375 2.0625 1.75 1.875 2.3125 1.5625 1.75 1.5625 1.4375 1.0625 1.375 2.0625 1.8125 1.1875 1.25 1.1875 6.6 6.6 5.9 6.9 6.2 7.1 5.9 6.3 1.9375 1.875 1.5 2.3125 1.25 1.9375 1.5625 1.6875 1.4375 1.9375 1.75 2.5625 1.875 2.625 1.4375 2.0625 2.0625 0.9375 1.875 2.5 2.1875 2.125 2.0625 1.8125 2.8125 2.75 2.5625 2.875 2.6875 2.875 2.0625 1.875 3.0625 2.75 4.2 4.8 4.1 4.4 4.5 4 3.9 4 4.4 4.2 к L 56.9 41.6 53.4 37.1 59.1 29.8 60.4 37.3 61.1 36.3 56.8 37.3 60 40.6 27.3 60.7 45.1 61.1 33.3 63.8 39.8 54 35.9 58 25.8 53.2 32.6 49.4 32.6 52.6 29.6 57.5 32.3 18.6 6 17.5 17.6 14.6 15.4 14.8 14.6 16.2 4 5.1 5.9 5.5 4.1 4.3
⠀ A 1 Team 2 New England Patriots 3 Denver Broncos 4 New Orleans Saints 5 Washington Redskins 6 Green Bay Packers 7 New York Giants 8 Atlanta Falcons 9 Houston Texans 10 Seattle Seahawks 11 Baltimore Ravens 12 San Francisco 49ers 13 Cincinnati Bengals 14 Tampa Bay Buccaneers 15 Minnesota Vikings 16 Dallas Cowboys 17 Chicago Bears 18 Detroit Lions 19 Carolina Panthers 20 Indianapolis Colts 08 B Year 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 PTS fx с D F PAVG 34.8 2.5625 7.266833 30.1 1.5 28.8 1.625 7.701087 7.453461 7.75 27.3 1.9375 27.1 1.4375 7.252149 26.8 2.1875 7.094955 1.9375 7.338542 26.2 26 1.8125 6.919075 25.8 1.9375 7.486166 24.9 1.5625 6.677143 24.8 1.5625 7.549451 24.4 1.875 6.615385 24.3 1.625 7.031073 1.375 5.692053 23.7 23.5 1 7.192214 23.4 2.75 6.184818 23.3 1.0625 6.650108 22.3 1.4375 7.522876 22.3 0.9375 6.564885 ΤΑ TO F SCK 1 1.56 1.5 0.88 1 1.31 1.13 1.06 1.13 1 1 1.63 1.44 1.44 1.81 1.5 2.06 1.38 1.69 1 62 G H FD RAVG 1.69 4.174312 1.31 3.803987 1.63 4.268398 2.06 5.225309 3.19 3.926199 1.25 4.546875 1.75 3.699153 1.75 4.172956 4.81194 2.06 2.38 4.273381 2.56 5.055195 2.88 4.055762 1.63 4.415385 2 5.414474 2.25 3.563063 2.75 4.187075 1.81 4.131148 2.25 4.515571 2.56 3.796364 2.06 3.552529 COMP THRD 25.44 0.625935 21.5 0.682065 20.7 0.630072 19.7 0.65942 18.61 0.670487 18.14 0.599407 19.78 0.6875 19.93 0.638728 17.62 0.640316 17.53 0.597143 18.8 0.663004 16.74 0.618343 17.36 0.548023 17.26 0.622517 19.55 0.659367 16.39 0.590759 22.25 0.600432 18.39 0.581699 19.88 0.53944 16.56 0.639394 0.487 0.451 0.44 0.358 0.423 0.406 0.451 0.376 0.402 0.369 0.351 0.341 0.358 0.371 0.439 0.365 0.425 0.431 0.428 0.378 L M
с F F 21.9 21.5 21 20.6 18.9 A 21 San Diego Chargers 22 Buffalo Bills 23 Pittsburgh Steelers 24 Tennessee Titans 25 Cleveland Browns 26 St. Louis Rams 27 Oakland Raiders 28 Miami Dolphins 29 New York Jets 30 Philadelphia Eagles 31 Jacksonville Jaguars 32 Arizona Cardinals 33 Kansas City Chiefs 34 18.7 B 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 2012 D E 1.75 6.239394 1.3125 6.404389 1.25 6.593315 1.5 6.14497 1.8125 6.064972 1.3125 6.376437 1.1875 6.496183 1 6.314286 1.4375 5.866883 0.8125 6.137306 1.4375 5.838798 2.0625 4.942105 0.8125 5.710438 1.63 2.13 1.88 1.75 1.63 1.38 1.63 H 3.06 3.552529 1.88 5.021739 2.31 3.724806 2.44 4.466102 2.25 4.016129 2.19 4.183594 1.69 3.778723 2.31 4.094545 2.94 3.834951 3 4.53876 3.13 3.821429 3.63 3.422727 2.5 4.782748 K 0.378 0.389 0.42 0.382 0.307 0.321 0.35 0.377 0.369 0.374 0.296 0.252 0.33 16.56 0.639394 17.44 0.605016 17.6 0.615599 14.78 0.588757 16.04 0.579096 16.74 0.597701 17 0.597964 15.69 0.580952 16.48 0.551948 18.84 0.593264 14.56 0.560109 14.13 0.555263 16.38 0.575758 18.1 18 17.6 17.5 15.9 15.6 13.2 1.63 2.31 2.31 1.63 2.13 2.31