Using an excel page only please
Refer to the Baseball 2012 data, which report information on the 30 Major League Baseball teams for the 2012 season.
a. Conduct a test of hypothesis to determine whether the mean salary of the teams was different from $80.0 million. Use the .05 significance level.
b. Using a 5% significance level, conduct a test of hypothesis to determine whether the mean attendance was more than 2,000,000 per team.
Lind, D., Marchel, W., & Wathen, S. (2015). Statistical Techniques in Business and Economics (16th ed.). McGraw-Hill Education