Another idea is to look at how a team's payroll impacts its home attendance. Higher payroll usually signals more higher-skilled players on a roster which should brings fans to the ballpark to see these players.Create 2 samples based on Team Salary and calculate average attendance, variance of attendance, and standard deviation of attendance for each sample.Sample 1 = 10 teams with the highest team salarySample 2 = 10 teams with the lowest team salary Tip: Use Excel's sorting tool to sort the data by salary (highest to lowest), and copy the 10 highest and 10 lowest into a separate part of the spreadsheet for easier analysis. Sample 1Sample 2 Top 10 Team SalaryBottom 10 Team SalarySample mean attendance mil milSample attendance variance mil milSample attendance standard deviation mil mil Perform a hypothesis test to determine whether there is a difference in the mean attendance of teams between the two groups created in Part F. Use a 0.05 level of significance in your testing procedures. Hint: When calculating your pooled sample variance and your test statistic, assume the Top 10 data is sample 1 and the Bottom 10 data is sample 2. Decision Rule-t < or t > = REJECT H0Value of Pooled Sample Variances Value of test statistic Decision: enter Reject or Do Not Reject Is there a difference in the mean attendance between the two groups assuming a 0.05 level of significance? Enter Yes or No. Another variable that can impact attendance is the team's win-loss record. Teams that are winning more games are thought to have increased attendance as fans prefer to see their home team "win" rather than "lose" (although for some teams such as the Chicago Cubs, this is not always an established relationship!). Create 2 samples based on Wins and calculate average wins, wins variance, and wins standard deviation for each sample.Sample 1 = 10 teams with the highest winsSample 2 = 10 teams with the lowest wins Team Salary ($ mil)ERA Year Stadium Opened Attendance (mil) Net Worth ($ bil)LeagueNationalTeamHRBАWinsArizona Diamondbacks143.321760.235823.7219982.2426951.21Atlanta BravesNational130.61750.257903.7520172.5557811.625Baltimore OriolesAmerican127.631880.239475.1819921.5641921.2Boston Red SoxChicago CubsChicago White SoxCincinnati Reds|American227.42080.2681083.7519122.8955752.8National194.261670.258953.6519143.1810892.9American71.841820.241624.8419911.6088171.5National100.311720.254674.6320031.6293561.01Cleveland IndiansAmerican142.82160.259913.7719941.9267011.045Colorado RockiesNational143.972100.256914.3319953.015881.1Detroit TigersHouston AstrosAmerican130.961350.241644.5820001.856971.225American163.522050.2551033.1120002.9805491.65Kansas City RoyalsLos Angeles AngelsLos Angeles DodgersMiami MarlinsMilwaukee BrewersAmerican129.941550.245584.9419731.6651071.015American173.782140.242804.1519663.0202161.8National199,582350.25923.3819623.8575National91.821280.237634.7620120.811104National108.982180.252963.7320012.8508751.03Minnesota TwinsAmerican115.511660.25784.520101.9591971.15New York MetsNational150.191700.234774.0720092.2249952.1New York YankeesAmerican179.62670.2491003.7820093.4828554Oakland AthleticsPhiladelphia PhilliesPittsburgh PiratesSan Diego PadresSan Francisco GiantsSeattle MarinersSt. Louis CardinalsAmerican80.322270.252973.8119661.5736161.02National104.31860.234804.1420042.1581241.7National91.031570.25482420011.4653161.26National101.341620.235664.420042.1685361.27American205.671760.254894.1320002,2994892.85National160.991330.239733.9519993.1561851.45National163.782050.249883.8520063.4035871.9|Tampa Bay RaysAmerican68.811500.258903.7419901.1549730.9Texas RangersAmerican140.631940.24674.9219942.1071071.6Toronto Blue JaysAmerican150.952170.244734.8519892.3252811.35Washington NationalsNational181.381910.254824.0420082.5296041.675

Team league Team salary ($Mn) HR BA Wins ERA Year Stadium Opened Attendance (Mn) Net worth ($Bn)…

Answered: Another idea is to look at how a team's…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Another idea is to look at how a team's payroll impacts its home attendance. Higher payroll usually signals more higher-skilled players on a roster which should brings fans to the ballpark to see these players.

Create 2 samples based on Team Salary and calculate average attendance, variance of attendance, and standard deviation of attendance for each sample.

Sample 1 = 10 teams with the highest team salary
Sample 2 = 10 teams with the lowest team salary

Tip: Use Excel's sorting tool to sort the data by salary (highest to lowest), and copy the 10 highest and 10 lowest into a separate part of the spreadsheet for easier analysis.

	Sample 1	Sample 2
	Top 10 Team Salary	Bottom 10 Team Salary
Sample mean attendance	mil	mil
Sample attendance variance	mil	mil
Sample attendance standard deviation	mil	mil

Perform a hypothesis test to determine whether there is a difference in the mean attendance of teams between the two groups created in Part F. Use a 0.05 level of significance in your testing procedures.

Hint: When calculating your pooled sample variance and your test statistic, assume the Top 10 data is sample 1 and the Bottom 10 data is sample 2.

Decision Rule	-t < or t > = REJECT H0
Value of Pooled Sample Variances
Value of test statistic
Decision: enter Reject or Do Not Reject

Is there a difference in the mean attendance between the two groups assuming a 0.05 level of significance? Enter Yes or No.

Another variable that can impact attendance is the team's win-loss record. Teams that are winning more games are thought to have increased attendance as fans prefer to see their home team "win" rather than "lose" (although for some teams such as the Chicago Cubs, this is not always an established relationship!).

Create 2 samples based on Wins and calculate average wins, wins variance, and wins standard deviation for each sample.

Sample 1 = 10 teams with the highest wins
Sample 2 = 10 teams with the lowest wins

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

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 5 images

SEE SOLUTION Check out a sample Q&A here