Try the fastest way to create flashcards

Related questions with answers

A multiple regression model is used to predict an NFL team's winning record (Win in %). For the explanatory variables, the average rushing yards (Rush) and the average passing yards (Pass) are used to capture offense, and the average yards allowed are used to capture defense (Yards Allowed). A portion of the data for the 2009 NFL season is shown in the accompanying table.

 Team  Win  Rush  Pass  Yards Allowed  Arizona Cardinals 62.5093.40251.00346.40 Atlanta Falcons 56.30117.21223.19348.90 :  Washington Redskins 25.0094.38218.13319.70\begin{array}{|l|c|c|c|c|} \hline \text { Team } & \text { Win } & \text { Rush } & \text { Pass } & \text { Yards Allowed } \\ \hline \text { Arizona Cardinals } & 62.50 & 93.40 & 251.00 & 346.40 \\ \hline \text { Atlanta Falcons } & 56.30 & 117.21 & 223.19 & 348.90 \\ \hline \text { : } & \vdots & \vdots & \vdots & \vdots \\ \hline \text { Washington Redskins } & 25.00 & 94.38 & 218.13 & 319.70 \\ \hline \end{array}

a. Estimate the model: Win =β0+β1=\beta_0+\beta_1 Rush +β2+\beta_2 Pass +β3+\beta_3 Yards Allowed +ε+\varepsilon.

b. Conduct a test at the 10%10 \% significance level to determine whether the impact of Rush is different from that of Pass in explaining Win, or β1+β2\beta_1+\beta_2.

Question

Is it defense or offense that wins football games? Consider the following portion of data, which includes a team's winning record (Win in %), the average number of yards gained, and the average number of yards allowed during the 20092009 NFL season.

 Team  Win  Yards Gained  Yards Allowed  Arizona Cardinals 62.50344.40346.40 Atlanta Falcons 56.30340.40348.90 Washington Redskins 25.00312.50319.70\begin{array}{|l|c|c|c|} \hline \text { Team } & \text { Win } & \text { Yards Gained } & \text { Yards Allowed } \\ \hline \text { Arizona Cardinals } & 62.50 & 344.40 & 346.40 \\ \hline \text { Atlanta Falcons } & 56.30 & 340.40 & 348.90 \\ \hline \vdots & \vdots & \vdots & \vdots \\ \hline \text { Washington Redskins } & 25.00 & 312.50 & 319.70 \\ \hline \end{array}

a. Compare two simple linear regression models, where Model 1 predicts the winning percentage based on Yards Gained and Model 2 uses Yards Allowed.

b. Estimate a multiple linear regression model, Model 3, that applies both Yards Gained and Yards Allowed to forecast the winning percentage. Is this model an improvement over the other two models? Explain.

Solution

Verified
Answered 1 year ago
Answered 1 year ago
Step 1
1 of 8

We are given a sample of wins, yards gained and yards allowed of 3232 teams.

Our goal is to estimate two simple linear regression models: one showing the influence of yards gained on the winning percentage and the other showing the influence of yards allowed on the winning percentage.

We can write these two models as:

(i)Win=β1,0+β1,1Yards made+ϵ(ii)Win=β2,0+β2,1Yards allowed+ϵ\begin{aligned} (i)\quad\text{Win}&=\beta_{1,0}+\beta_{1,1} \text{Yards made}+\epsilon\\ (ii)\quad\text{Win}&=\beta_{2,0}+\beta_{2,1} \text{Yards allowed}+\epsilon \end{aligned}

We want to compare them.

How do we estimate these models?

Create a free account to view solutions

Create a free account to view solutions

Recommended textbook solutions

Business Statistics 2nd Edition by Norean D. Sharpe, Paul Velleman, Richard D. De Veaux

Business Statistics

2nd EditionISBN: 9780321955081Norean D. Sharpe, Paul Velleman, Richard D. De Veaux
2,183 solutions
Business Statistics 2nd Edition by Norean D. Sharpe, Paul Velleman, Richard D. De Veaux

Business Statistics

2nd EditionISBN: 9780321955098Norean D. Sharpe, Paul Velleman, Richard D. De Veaux
2,183 solutions
Essentials of Modern Business Statistics with Microsoft Excel 8th Edition by David R. Anderson, Dennis J. Sweeney, James J Cochran, Jeffrey D. Camm, Thomas A. Williams

Essentials of Modern Business Statistics with Microsoft Excel

8th EditionISBN: 9780357131626 (1 more)David R. Anderson, Dennis J. Sweeney, James J Cochran, Jeffrey D. Camm, Thomas A. Williams
1,797 solutions
Business Statistics: Communicating with Numbers 3rd Edition by Alison Kelly, Sanjiv Jaggia

Business Statistics: Communicating with Numbers

3rd EditionISBN: 9781259957611Alison Kelly, Sanjiv Jaggia
2,449 solutions

More related questions

1/4

1/7