Excel assignment | BUSU610 | Brandman University

 

Using the McGraw-Hill Dataset in the Excel file, located here, 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.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer