70.2K

Verified Solution

Link Copied!

St. Louis Cardinal catcher Yadier Molina's batting average for the 2021 MLB regular season is recorded as 254. The team batting averages for 30 MLB teams are given here to the left Considering Molina's average as the population mean, is the MLB average different than Molina's average? Hint: You are permitted to use Excel statistical functions 1) Specify HA 2) 2 In the context of this problem, describe what would be Type I error and what would be Type Il error 3) Inspect the sample data to determine whether it is reasonably normally distributed and whether there are any outliers (note - there are many different ways to do this - any of which are acceptable provided they are properly employed and described) TEAM TAVERAGE Houston 268 Toronto 266 Boston 263 Washington 258 Chi Sox 257 Colorado 249 Cincinnati 249 Kansas City 248 SF Giants 247 LA Angels 244 Atlanta 244 LA Dodgers 244 St. Louis 243 San Diego 243 Tampa Bay 242 Detroit 241 Minnesota 241 Philadelphia 240 Baltimore 239 NY Mets 238 Cleveland 238 Oakland 238 NY Yankees 237 Pittsburgh 236 Chi Cubs 236 Arizona 236 Miami 232 Milwaukee 232 Texas 232 Seattle 225 4) Regardless of your findings in (3) above, state the appropriate statistical conclusion You must show all calculations below, but you may use relevant statistical functions (e.g. VAR.S, AVERAGE, NORM.DIST, etc) St. Louis Cardinal catcher Yadier Molina's batting average for the 2021 MLB regular season is recorded as 254. The team batting averages for 30 MLB teams are given here to the left Considering Molina's average as the population mean, is the MLB average different than Molina's average? Hint: You are permitted to use Excel statistical functions 1) Specify HA 2) 2 In the context of this problem, describe what would be Type I error and what would be Type Il error 3) Inspect the sample data to determine whether it is reasonably normally distributed and whether there are any outliers (note - there are many different ways to do this - any of which are acceptable provided they are properly employed and described) TEAM TAVERAGE Houston 268 Toronto 266 Boston 263 Washington 258 Chi Sox 257 Colorado 249 Cincinnati 249 Kansas City 248 SF Giants 247 LA Angels 244 Atlanta 244 LA Dodgers 244 St. Louis 243 San Diego 243 Tampa Bay 242 Detroit 241 Minnesota 241 Philadelphia 240 Baltimore 239 NY Mets 238 Cleveland 238 Oakland 238 NY Yankees 237 Pittsburgh 236 Chi Cubs 236 Arizona 236 Miami 232 Milwaukee 232 Texas 232 Seattle 225 4) Regardless of your findings in (3) above, state the appropriate statistical conclusion You must show all calculations below, but you may use relevant statistical functions (e.g. VAR.S, AVERAGE, NORM.DIST, etc)

Answer & Explanation Solved by verified expert

See Answer