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.
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.
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Major League Baseball (MLB) consists of teams that play in the American League and the National League. MLB collects a wide variety of team and player statistics. Some of the statistics often used to evaluate pitching performance are as follows:
· ERA: The average number of earned runs given up by the pitcher per nine innings. An earned run is any run that the opponent scores off a particular pitcher except for runs scored as a result of errors.
· SO/IP: The average number of strikeouts per inning pitched.
· HR/IP: The average number of home runs per inning pitched.
· R/IP: The number of runs given up per inning pitched.
The data in the Excel Online file below show values for these statistics for a random sample of 20 pitchers from the American League for a season. Construct a spreadsheet to answer the following questions.
Complete the equation below for an estimated regression equation developed to predict the average number of runs given up per inning pitched (R/IP) given the average number of strikeouts per inning pitched (SO/IP) and the average number of home runs per inning pitched (HR/IP) (to 3 decimals).
Weekly Gross
Revenue (1000s)
Television
Advertising
($1000s)
Newspaper
Advertising
($1000s)
9761.5
9022
9551.5
922.52.5
9543.3
943.52.3
942.54.2
9442.5
Predicted Revenue
4.83.7
PlayerTeamWLERASO/IPHR/IPR/IP
Verlander, JDET2452.410.090.28
Beckett, JBOS1372.890.910.110.34
Wilson, CTEX1672.930.910.070.39
Sabathia, CNYY19830.970.070.36
Haren, DLAA16103.160.810.070.37
McCarthy, BOAK993.310.720.050.42
Santana, ELAA11123.370.780.110.41
Lester, JBOS1593.460.950.090.39
Hernandez, FSEA14143.470.940.080.42
Buehrle, MCWS1393.590.530.090.45
Pineda, M
SEA9103.7410.110.44
Colon, BNYY8103.990.820.120.51
Tomlin, JCLE1274.240.530.150.48
Pavano, CMIN9134.290.460.090.55
Danks, JCWS8124.320.790.10.51
Guthrie, JBAL9174.320.630.130.53
Lewis, CTEX14104.390.830.160.51
Scherzer, MDET1594.430.880.140.51
Davis, WTB11104.450.560.120.51
Porcello, RDET1494.750.570.090.56
TeamConfYds/AttInt/AttWin%
Arizona CardinalsNFC6.50.04249.9
Atlanta FalconsNFC7.10.02362.6
Carolina PanthersNFC7.50.03437.3
Cincinnati BengalsAFC6.20.02756.2
Detroit LionsNFC7.30.02362.6
Green Bay PackersNFC8.80.01493.7
Houstan TexansAFC7.60.01862.2
Indianapolis ColtsAFC5.40.02712.3
Jacksonville JaguarsAFC4.50.03231.3
Minnesota VikingsNFC5.80.03218.6
New England PatriotsAFC8.30.01981.4
New Orleans SaintsNFC80.0281
Oakland RaidersAFC7.70.04349.9
San Francisco 49ersNFC6.50.01281.4
Tennessee TitansAFC6.50.02456.4
Washington RedskinsNFC6.50.0431.1
TeamConfYds/AttInt/AttWin%Part a.
Arizona CardinalsNFC6.30.04150.1
Atlanta FalconsNFC70.02262.2
Carolina PanthersNFC7.30.03337.4
Cincinnati BengalsAFC60.02556.2
Detroit LionsNFC7.30.02562.2
Green Bay PackersNFC8.70.01593.5
Houstan TexansAFC7.50.01962.5
Indianapolis ColtsAFC5.50.02512.5
Jacksonville JaguarsAFC4.70.03331
Minnesota VikingsNFC5.80.03318.8
New England PatriotsAFC8.40.02181.1
New Orleans SaintsNFC7.90.0281
Oakland RaidersAFC7.40.04549.7
San Francisco 49ersNFC6.30.0181.4
Tennessee TitansAFC6.70.02456.2
Washington RedskinsNFC6.30.04131.4
Part b.
