Refer to the Baseball 2018 data, which report information on the 30 Major League Baseball teams for the 2018 season. Consider the following variables: number of wins, payroll, season attendance, whether the team is in the American or National League, and the number of home runs hit.

Prepare a report on the team salaries. Be sure to answer the following questions in your report.

1. Over the last decade, the mean attendance per team followed a normal distribution with a mean of 2.45 million per team and a standard deviation of .71 million. Compute the mean attendance per team for the 2018 season. Determine the likelihood of a sample mean attendance this large or larger from the population.
2. Develop a 95% confidence interval for the mean number of home runs per team.
3. Develop a 95% confidence interval for the mean batting average by each team.
4. Develop a 95% confidence interval for the mean earned run average (ERA) for each team.
5. Conduct a test of hypothesis to determine whether the mean salary of the teams was different from $100.0 million. Use the .05 significance level.
6. Using a 5% significance level, conduct a test of hypothesis to determine whether the mean attendance was more than 2,000,000 per team.
7. 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?
8. 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 National
9. League?
10. Compute the mean and the standard deviation of the number of wins for the 10 teams with the highest salaries.
    1. Do the same for the 10 teams with the lowest salaries.
    2. At the .05 significance level, is there a difference in the mean number of wins for the two groups (highest and lowest salaries)?
    3. At the .05 significance level, is there a difference in the mean attendance for the two groups (highest and lowest salaries)

Team League Arizona Diamondbacks National Atlanta Braves National Baltimore Orioles American Boston Red Sox American Chicago Cubs National Chicago White Sox American Cincinnati Reds National Cleveland Indians American Colorado Rockies National Detroit Tigers American Houston Astros American Kansas City Royals American Los Angeles Angels American Los Angeles Dodgers National Miami Marlins National Milwaukee Brewers National Minnesota Twins American New York Mets National New York Yankees American Oakland Athletics American Philadelphia Phillies National Pittsburgh Pirates National San Diego Padres National San Francisco Giants American Seattle Mariners National St. Louis Cardinals National Tampa Bay Rays American Texas Rangers American Toronto Blue Jays American Washington Nationals National Team Salary ($ mil) HR 143.32 130.6 127.63 227.4 194.26 71.84 100.31 142.8 143.97 130.96 163.52 129.94 173.78 199.58 91.82 108.98 115.51 150.19 179.6 80.32 104.3 91.03 101.34 205.67 160.99 163.78 68.81 140.63 150.95 181.38 Year Stadiur Attendance Net Worth BA Wins ERA Opened mil $ bil 176 0.235 82 3.72 1998 2.242695 1.21 175 0.257 90 3.75 2017 2.555781 1.625 188 0.239 47 5.18 1992 1.564192 1.2 208 0.268 108 3.75 1912 2.895575 2.8 167 0.258 95 3.65 1914 3.181089 2.9 182 0.241 62 4.84 1991 1.608817 1.5 172 0.254 67 4.63 2003 1.629356 1.01 216 0.259 91 3.77 1994 1.926701 1.045 210 0.256 91 4.33 1995 3.01588 11 135 0.241 64 4.58 2000 1.85697 1.225 205 0.255 103 3.11 2000 2.980549 1.65 155 0.245 58 4.94 1973 1.665107 1.015 214 0.242 80 4.15 1966 3.020216 1.8 235 0.25 92 3.38 1962 3.8575 3 128 0.237 63 4.76 2012 0.811104 1 218 0.252 96 3.73 2001 2.850875 1.03 166 0.25 78 4.5 2010 1.959197 1.15 170 0.234 77 4.07 2009 2.224995 2.1 267 0.249 100 3.78 2009 3.482855 4 227 0.252 97 3.81 1966 1.573616 1.02 186 0.234 80 4.14 2004 2.158124 1.7 157 0.254 82 4 2001 1.465316 1.26 162 0.235 66 4.4 2004 2.168536 1.27 176 0.254 89 4.13 2000 2.299489 2.85 133 0.239 73 3.95 1999 3.156185 1.45 205 0.249 88 3.85 2006 3.403587 1.9 150 0.258 90 3.74 1990 1.154973 0.9 194 0.24 67 4.92 1994 2. 107107 1.6 217 0.244 73 4.85 1989 2.325281 191 0.254 82 4.04 2008 2.529604 1.675 135