Using an excel page only please

1. Chapter 10 Problem 51

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