a. 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). Win% = b + b - Yds/Att bo = bị = b. 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). Win% = bo + bị · Int/Att bo = c. 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). Win% = b, + b, · Yds/Att + bz · Int/Att bo = bị = b2 = d. The 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 whole number). Predicted percentage Actual percentage

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 22PFA
icon
Related questions
icon
Concept explainers
Question

Trying to find the answers to A-D

1
Team
Conf
Yds/Att
Int/Att
Win%
Arizona Cardinals
NFC
6.5
0.041
49.7
Atlanta Falcons
NFC
6.9
0.022
62.6
4
Carolina Panthers
NFC
7.5
0.032
37.6
Cincinnati Bengals
Detroit Lions
AFC
6.2
0.027
56.1
NFC
7.2
0.024
62.3
7
Green Bay Packers
NFC
8.9
0.014
93.8
8
Houstan Texans
AFC
7.6
0.018
62.3
9 Indianapolis Colts
10 Jacksonville Jaguars
11 Minnesota Vikings
12 New England Patriots
13 New Orleans Saints
AFC
5.7
0.027
12.2
AFC
4.6
0.031
31.0
NFC
5.8
0.033
18.8
AFC
8.2
0.019
81.2
NFC
8.2
0.021
81.2
14 Oakland Raiders
AFC
7.5
0.043
49.8
81.0
San Francisco 49ers
NFC
6.3
0.011
15
16 Tennessee Titans
17 Washington Redskins
18
19
20
21
22
23
24
AFC
6.8
0.025
56.0
NFC
6.5
0.040
31.0
25
26
595 229 676 O22N 530O 5
667 O7 o N54 5o co N6 O6
Transcribed Image Text:1 Team Conf Yds/Att Int/Att Win% Arizona Cardinals NFC 6.5 0.041 49.7 Atlanta Falcons NFC 6.9 0.022 62.6 4 Carolina Panthers NFC 7.5 0.032 37.6 Cincinnati Bengals Detroit Lions AFC 6.2 0.027 56.1 NFC 7.2 0.024 62.3 7 Green Bay Packers NFC 8.9 0.014 93.8 8 Houstan Texans AFC 7.6 0.018 62.3 9 Indianapolis Colts 10 Jacksonville Jaguars 11 Minnesota Vikings 12 New England Patriots 13 New Orleans Saints AFC 5.7 0.027 12.2 AFC 4.6 0.031 31.0 NFC 5.8 0.033 18.8 AFC 8.2 0.019 81.2 NFC 8.2 0.021 81.2 14 Oakland Raiders AFC 7.5 0.043 49.8 81.0 San Francisco 49ers NFC 6.3 0.011 15 16 Tennessee Titans 17 Washington Redskins 18 19 20 21 22 23 24 AFC 6.8 0.025 56.0 NFC 6.5 0.040 31.0 25 26 595 229 676 O22N 530O 5 667 O7 o N54 5o co N6 O6
目
Video
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
a. 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).
Win% = bo + bı · Yds/Att
bo =
b, =
b. 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).
Win% = bo + bị · Int/Att
bo =
b, =
c. 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).
Win% = bo + bị · Yds/Att + b2 · Int/Att
bo =
b, =
b2 =
d. The 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 whole number).
Predicted percentage
Actual percentage
Transcribed Image Text:目 Video 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 a. 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). Win% = bo + bı · Yds/Att bo = b, = b. 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). Win% = bo + bị · Int/Att bo = b, = c. 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). Win% = bo + bị · Yds/Att + b2 · Int/Att bo = b, = b2 = d. The 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 whole number). Predicted percentage Actual percentage
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
Points, Lines and Planes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
PREALGEBRA
PREALGEBRA
Algebra
ISBN:
9781938168994
Author:
OpenStax
Publisher:
OpenStax
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt