Major League Baseball (MLB) consists of teams that play in the American League and the Nabional League. Mi.B collects a wide variety of team and player statistici. Some of the statistics often used to evaluate pitching performance are as follows: - ERA: The average mumber of eamed runs given up by the pitcher per nine innings. Mn earned nun is any nun that the opponent scores off a particular patcher except for runs scored as a result of errors. - 50/1P: The average number of strikeouts per inning pitched. - HIV/P. 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 Onlone file below show values for these statistics for a random sample of 20 pitchers from the American League for a seasonv Construct a spreadsheet to answer the following questions. Due to a recent change by Microsoft you will need to open the XL Miner Analysis ToolPak add-in manually from the home nbbon, Sireenshob ef Toci Pak Open spreadsheet Complete the equation below for an estimated regression equation developed to predict the average number of runs given up per inring sitched (R/P) given the average number of strikeouts per inning pitched (SO/tP) and the average number of home runs per inring pitched (1ridip) (to 3 deomals). R/IP=+SO/IP+ HR/IP a. Use the F test to determine the overall signficance of the relationstup. Compute F test stabstic (to 2 decimals). The p-value is (to-3 decimals), What is your condusion at the , 05 level of significance? There a significant overall relabonship. 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 condusion at the .05 level of significance? SO/IP 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 significant