Team Conf Yds/Att Int/Att Win% Arizona Cardinals NFC 6.3 0.041 50.1 Atlanta Falcons NFC 7.0 0.021 62.2 Carolina Panthers NFC 7.2 0.032 37.3 Cincinnati Bengals AFC 6.2 0.026 56.2 Detroit Lions NFC 7.2 0.024 62.6 Green Bay Packers NFC 9.0 0.013 93.7 Houstan Texans AFC 7.6 0.018 62.3 Indianapolis Colts AFC 5.6 0.026 12.2 Jacksonville Jaguars AFC 4.4 0.031 31.4 Minnesota Vikings NFC 5.8 0.033 18.5 New England Patriots AFC 8.1 0.021 81.1 New Orleans Saints NFC 8.1 0.020 81.3 Oakland Raiders AFC 7.6 0.043 50.0 San Francisco 49ers NFC 6.5 0.012 81.3 Tennessee Titans AFC 6.5 0.023 56.0 Washington Redskins NFC 6.4 0.040 31.4 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. Open spreadsheet Develop 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). Develop 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). Develop 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).

Holt Mcdougal Larson Pre-algebra: Student Edition 2012

1st Edition

ISBN:9780547587776

Author:HOLT MCDOUGAL

Publisher:HOLT MCDOUGAL

Chapter11: Data Analysis And Probability

Section11.4: Collecting Data

Problem 2E

See similar textbooks

Related questions

Question

Team	Conf	Yds/Att	Int/Att	Win%
Arizona Cardinals	NFC	6.3	0.041	50.1
Atlanta Falcons	NFC	7.0	0.021	62.2
Carolina Panthers	NFC	7.2	0.032	37.3
Cincinnati Bengals	AFC	6.2	0.026	56.2
Detroit Lions	NFC	7.2	0.024	62.6
Green Bay Packers	NFC	9.0	0.013	93.7
Houstan Texans	AFC	7.6	0.018	62.3
Indianapolis Colts	AFC	5.6	0.026	12.2
Jacksonville Jaguars	AFC	4.4	0.031	31.4
Minnesota Vikings	NFC	5.8	0.033	18.5
New England Patriots	AFC	8.1	0.021	81.1
New Orleans Saints	NFC	8.1	0.020	81.3
Oakland Raiders	AFC	7.6	0.043	50.0
San Francisco 49ers	NFC	6.5	0.012	81.3
Tennessee Titans	AFC	6.5	0.023	56.0
Washington Redskins	NFC	6.4	0.040	31.4

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.

Open spreadsheet

Develop 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).
Develop 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).
Develop 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).

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here