Trying to find the answers to the x's and empty boxes. This was all the information I was given. Player2 Verlander, JBeckett, JWilson, C1TeamLERASO/IPHR/IPR/IPDET242.391.000.090.28After reading these ins tructions delete all text in this shaded area.BOS1372.890.900.100.33TEX162.940.920.060.40Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis.4.Sabathia, CNYYLAAOAKLAA0.060.081982.990.960.360.810.38Haren, D7 McCarthy, B8 Santana, E9 Lester, J10 Hernandez, F11 Buehrle, M12 Pineda, M13 Colon, B16103.17After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (J2).93.310.710.060.4311123.370.780.100.41Your Linear Regression analysis output should fit into this shaded area.BOS1593.460.950.090.39SEA14143.470.940.070.41CWS1393.580.520.090.44SEA9103.731.010.110.440.130.15NYY8104.000.810.510.470.5414 Tomlin, JCLE1274.240.5415 Pavano, C16 Danks, J17 Guthrie, J18 Lewis, C19 Scherzer, M20 Davis, W21 Porcello, RMIN9134.290.450.09CWS8.124.320.790.100.52BAL9174.320.620.120.54TEX14104.400.840.160.500.150.130.09DET1594.430.890.514.444.74ТВ11100.570.51DET140.560.56222324252627 VideoMajor 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.Open spreadsheetComplete 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 inningpitched (HR/IP) (to 3 decimals).R/IP = 0.537so/IP +HR/IPa. Use the F test to determine the overall significance of the relationship.Compute F test statistic (to 2 decimals).The p-value is(to 3 decimals).What is your conclusion at the .05 level of significance?There isO a significant overall relationship.b. Use the t test to determine the significance of each independent variable.Compute the t test statistic for the significance of SO/IP (to 2 decimals).The p-value is(to 3 decimals).What is your conclusion at the .05 level of significance?so/IP is0 significant.Compute the t test statistic for the significance of HR/IP (to 2 decimals).The p-value is(to 3 decimals).What is your conclusion at the .05 level of significance?HR/IP issignificant.Check My WorkReset Problem

Name: Trying to find the answers to the x's and empty boxes. This was all th
Uploaded: 2024-03-20T06:46:14.000Z
Channel: Bartleby
Description: Trying to find the answers to the x's and empty boxes. This was all the information I was given. Player2 Verlander, JBeckett, JWilson, C1TeamLERASO/IPHR/IPR/IPDET242.391.000.090.28After reading these ins tructions delete all text in this shaded area.