Ch7. Ex10. 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.

SUMMARY OUTPUT Regression Statistics MultipleRRSquareAdjustedRSquareStandardErrorObservations0.5040107570.2540268430.212583890.0699467520 ANOVA InterceptHR/IPCoefficients0.3038972811.418932528StandardError0.0596845690.573122273tStat5.0917227732.475793727P-value7.62E050.023457Lower95%0.1785046550.214847328Upper95%0.42928992.6230177Lower95%0.1785046550.214847328Upper95%0.42928992.6230177 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). 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 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 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