All information (question & data from spreadsheet to solve) are posted below. Thank you in advance for your help!

tivity 2 - Multiple Regression, F-Test for Overall Significance, t-Test for Variable Significance (Structured) Video 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. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak X Open spreadsheet 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 (50/IP) and the average number of home runs per inning pitched (HR/IP) (to 3 decimals). R/IP - SO/IP + HR/IP a. 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 is :@ a significant overall relationship. b. Use the f test to determine the significance of each independent variable. Compute the $ 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 is :@ significant. Compute the $ 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 | is :@ significant. Activity FrameA B C D E F G H K M N P Player Team W L ERA SOAP HR/IP R/IP Verlander, J DET 24 5 2.39 1.00 0.10 0.28 After reading these instructions delete all text in this shaded area. Beckett, J BOS 13 7 2.8B 0.90 0.10 0.34 Wilson, C TEX 16 7 2.93 0.91 0.07 0.40 Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis. Sabathia, C NYY 19 8 2.99 0.97 0.06 0.37 Haren, D LAA 16 10 3.16 0.81 0.08 0.38 After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (J2). Mccarthy, B OAK 9 9 3.32 0.71 0.06 0.43 Santana, E LAA 11 12 3.37 0.77 0.10 0.42 Your Linear Regression analysis output should fit into this shaded area. Lester, J BOS 15 9 3.47 0.94 0.09 0.39 Hernandez, F SEA 14 14 3.46 0.94 0.07 0.42 Buehrle, M CWS 13 9 3.58 0.52 0.09 0.45 Pineda, M SEA 9 10 3.74 1.00 0.11 0.43 Colon, B NYY 8 10 4.00 0.82 0.12 0.51 Tomlin, J CLE 12 7 4.24 0.54 0.14 0.47 Pavano, C MIN 9 13 4.30 0.45 0.09 0.55 Danks, J CWS 12 4.33 0.79 0.10 0.52 Guthrie, J BAL 9 17 4.33 0.63 0.13 0.53 Lewis, C TEX 14 10 4.39 0.83 0.16 0.50 Scherzer, M DET 15 9 4.42 0.88 0.15 0.51 Davis, W TB 11 10 4.44 0.56 0.12 0.52 Porcello, R DET 14 9 4.74 0.57 0.10 0.57Major 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. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak X Open spreadsheet 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 (50/IP) and the average number of home runs per inning pitched (HR/IP) (to 3 decimals). R/IP - 0.511 + -0.540 80/IP + 1.212 O HR/IP a. Use the F test to determine the overall significance of the relationship. Compute F test statistic (to 2 decimals). 11.64 The p-value is 0.001 (to 3 decimals). What is your conclusion at the .05 level of significance? There is :@ a significant overall relationship. b. Use the f test to determine the significance of each independent variable. Compute the f test statistic for the significance of SO/IP (to 2 decimals). 3.40 The p-value is 0.003 @(to 3 decimals). What is your conclusion at the .05 level of significance? SO/IP | is :@ significant. Compute the $ test statistic for the significance of HR/IP (to 2 decimals). 2.69 Activity Frame The p-value is 0.015 (to 3 decimals). What is your conclusion at the .05 level of significance? HR/IP| is :@ significant