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