For Questions 8-10, use the data on the NCAA Pitching Data 5 tab. 6 Calculate the...

Transcribed Image Text:

For Questions 8-10, use the data on the "NCAA Pitching Data" 5 tab. 6 Calculate the following sample statistics for the "Wins" Variable: 7 8 59 Sample size n ==> Sample Mean X-Bar==> Sample Variance S==> Q8. Based on these sample statistics, calculate the LCL and UCL 50 for a 90% confidence interval of the mean Wins. 31 62 63 a. LCL--> b. UCL ==> Q9. In the column labeled "Wins > Losses" use the Excel IF function to create a "Yes/No" variable equal to 1 if "Wins" (column E) is greater than "Losses" (column F) and zero otherwise. Using the Normal approximation to the Binomial distribution, calculate the LCL and UCL for a 90% CI (a = 0.1) for the proportion of 64 pitchers with Wins greater than Losses. 65 66 67 68 a. Sample Proportion -P-hat => b. LCL==> c. UCL ==> Q10. For the "ERA" variable, calculate the Sample Variance S the 69 LCL and UCL for a 95% CI (a = 0.05) for the variance of ERA. a. Sample Variance S==> 70 71 b. LCL==> 72 c. UCL-> 73 74 For Questions 8-10, use the data on the "NCAA Pitching Data" 5 tab. 6 Calculate the following sample statistics for the "Wins" Variable: 7 8 59 Sample size n ==> Sample Mean X-Bar==> Sample Variance S==> Q8. Based on these sample statistics, calculate the LCL and UCL 50 for a 90% confidence interval of the mean Wins. 31 62 63 a. LCL--> b. UCL ==> Q9. In the column labeled "Wins > Losses" use the Excel IF function to create a "Yes/No" variable equal to 1 if "Wins" (column E) is greater than "Losses" (column F) and zero otherwise. Using the Normal approximation to the Binomial distribution, calculate the LCL and UCL for a 90% CI (a = 0.1) for the proportion of 64 pitchers with Wins greater than Losses. 65 66 67 68 a. Sample Proportion -P-hat => b. LCL==> c. UCL ==> Q10. For the "ERA" variable, calculate the Sample Variance S the 69 LCL and UCL for a 95% CI (a = 0.05) for the variance of ERA. a. Sample Variance S==> 70 71 b. LCL==> 72 c. UCL-> 73 74