48. Refer to the Baseball 2016 data, which report information on the 30 Major LeagueBaseball teams for the 2016 season.a. At the .05 significance level, can we conclude that there is a difference in the mean salary of teams in the American League versus teams in the National League?b. At the .05 significance level, can we conclude that there is a difference in the mean home attendance of teams in the American League versus teams in the NationalLeague?c. Compute the mean and the standard deviation of the number of wins for the10 teams with the highest salaries. Do the same for the 10 teams with the lowest salaries. At the .05 significance level, is there a difference in the mean number of wins for the two groups? At the .05 significance level, is there a difference in the mean attendance for the two groups?

Data:

https://docs.google.com/spreadsheets/d/1a0TF_SC49PVCNQh9gvr1pxo84_YJw8RbYeyobZbabDQ/edit?usp=sharing

Kindly explain the answer with formula's for excel