The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the data in the Excel Online file below show the conference (Conf), average number of passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won (Win%) for a random sample of 16 NFL teams for a season. Construct a spreadsheet to answer the following questions.Data:TeamConfYds/AttInt/AttWin%Arizona CardinalsNFC6.60.04249.7Atlanta FalconsNFC6.90.02262.4Carolina PanthersNFC7.50.03237.2Cincinnati BengalsAFC6.00.02556.1Detroit LionsNFC7.00.02462.6Green Bay PackersNFC8.90.01493.6Houstan TexansAFC7.30.01862.5Indianapolis ColtsAFC5.70.02712.4Jacksonville JaguarsAFC4.40.03331.0Minnesota VikingsNFC5.90.03218.8New England PatriotsAFC8.30.02181.4New Orleans SaintsNFC8.10.02181.3Oakland RaidersAFC7.40.04449.9San Francisco 49ersNFC6.60.01181.3Tennessee TitansAFC6.80.02556.2Washington RedskinsNFC6.40.04031.0 ### Regression Analysis of Football Game OutcomesOn this page, learners will explore how to develop regression equations to predict the percentage of games won based on specific team performance metrics. #### Part A: Predicting Games Won Based on Passing Yards per AttemptDevelop the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt (to 1 decimal).\[ \text{Win%} = b_0 + b_1 \cdot \text{Yds/Att} \]Where:- \( b_0 \) = - \( b_1 \) = #### Part B: Predicting Games Won Based on Interceptions per AttemptDevelop the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt (to 1 decimal).\[ \text{Win%} = b_0 + b_1 \cdot \text{Int/Att} \]Where:- \( b_0 \) = - \( b_1 \) = #### Part C: Predicting Games Won Based on Multiple VariablesDevelop the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt and the number of interceptions thrown per attempt (to 1 decimal).\[ \text{Win%} = b_0 + b_1 \cdot \text{Yds/Att} + b_2 \cdot \text{Int/Att} \]Where:- \( b_0 \) = - \( b_1 \) = - \( b_2 \) = #### Part D: Practical Application to the Kansas City ChiefsThe average number of passing yards per attempt for the Kansas City Chiefs was 6.2 and the number of interceptions thrown per attempt was 0.036. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the Kansas City Chiefs. *(Note: For this season the Kansas City Chiefs' record was 7 wins and 9 losses.)* Compare your prediction to the actual percentage of games won by the Kansas City Chiefs (to the nearest whole number).- Predicted percentage:- Actual percentage:##### Explanation of Diagram/Graph:In this section, no graphs or diagrams are provided. The theoretical development and subsequent application focus solely on the creation and use of regression

TeamConfYds/AttInt/AttWin%Arizona CardinalsNFC6.60.04249.7Atlanta FalconsNFC6.90.02262.4Carolina…

Answered: AE Open spreadsheet a. Develop the…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

100%

The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the data in the Excel Online file below show the conference (Conf), average number of passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won (Win%) for a random sample of 16 NFL teams for a season. Construct a spreadsheet to answer the following questions.

Data:

Team	Conf	Yds/Att	Int/Att	Win%
Arizona Cardinals	NFC	6.6	0.042	49.7
Atlanta Falcons	NFC	6.9	0.022	62.4
Carolina Panthers	NFC	7.5	0.032	37.2
Cincinnati Bengals	AFC	6.0	0.025	56.1
Detroit Lions	NFC	7.0	0.024	62.6
Green Bay Packers	NFC	8.9	0.014	93.6
Houstan Texans	AFC	7.3	0.018	62.5
Indianapolis Colts	AFC	5.7	0.027	12.4
Jacksonville Jaguars	AFC	4.4	0.033	31.0
Minnesota Vikings	NFC	5.9	0.032	18.8
New England Patriots	AFC	8.3	0.021	81.4
New Orleans Saints	NFC	8.1	0.021	81.3
Oakland Raiders	AFC	7.4	0.044	49.9
San Francisco 49ers	NFC	6.6	0.011	81.3
Tennessee Titans	AFC	6.8	0.025	56.2
Washington Redskins	NFC	6.4	0.040	31.0