excel assignment

 

Using the McGraw-Hill Dataset in the Excel file, , complete the following tasks:

Task#1: Compute the mean number of home runs per game. To do this, first find the mean number of home runs per team. Next, divide this value by 162 (a season comprises 162 games); then multiply by 2 because there are two teams in each game. Use the Poisson distribution to estimate the number of home runs that will be hit in a game. Find the probability:

1) There are no home runs in a game.

2) There are two home runs in a game.

3) There are at least 4 home runs in a game.

Task #2

1) The mean attendance per team for the season was 2.439 million, with a standard deviation of 0.618 million. Use the normal distribution to estimate the number of teams with attendance of more than 3.5 million. Compare that estimate with the actual number. Comment on the accuracy of your estimate.

2) The mean team salary was $121 million, with a standard deviation of $40.0 million. Use the normal distribution to estimate the number of teams with a team salary of more than $100 million. Compare that estimate with the actual number. Comment on the accuracy of your estimate.