The International League of Triple-A minor league baseball consists of 14 teams organized into three divisions: North, South, and West. The data showing the average attendance for the 14 teams in the International League are contained in the Excel Online file below. Also shown are the teams' records; W denotes the number of games won, L denotes the number of games lost, and PCT is the proportion of games played that were won. Construct a spreadsheet to answer the following questions.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Trying to find the LSD's

Video
The International League of Triple-A minor league baseball consists of 14 teams organized into three divisions: North, South, and West. The data showing the average attendance for the 14 teams in the International League
are contained in the Excel Online file below. Also shown are the teams' records; W denotes the number of games won, L denotes the number of games lost, and PCT is the proportion of games played that were won.
Construct a spreadsheet to answer the following questions.
Open spreadsheet
a. Use a = .05 to test for any difference in the mean attendance for the three divisions.
Calculate the value of the F-statistic (to 2 decimals).
6.91
The p-value is 0.011
O (to 4 decimals).
What is your conclusion?
There is sufficient
VO evidence to conclude that the mean attendance values are not the same across the three divisions of the International League of Triple-A minor league baseball.
b. Use Fisher's LSD procedure to test whether there is a significant difference between the means for North (1), South (2), and West (3). Use a = .05.
Absolute Value
(to 2 decimals)
LSD
(to 2 decimals)
Difference
Conclusion
2158.58 O
1630.01
Significant difference
700.92
1630.01
No significant difference v
T2 – T3
2859.50 O
2075.52 X
Significant difference
Check My Work
Reset Problem
Transcribed Image Text:Video The International League of Triple-A minor league baseball consists of 14 teams organized into three divisions: North, South, and West. The data showing the average attendance for the 14 teams in the International League are contained in the Excel Online file below. Also shown are the teams' records; W denotes the number of games won, L denotes the number of games lost, and PCT is the proportion of games played that were won. Construct a spreadsheet to answer the following questions. Open spreadsheet a. Use a = .05 to test for any difference in the mean attendance for the three divisions. Calculate the value of the F-statistic (to 2 decimals). 6.91 The p-value is 0.011 O (to 4 decimals). What is your conclusion? There is sufficient VO evidence to conclude that the mean attendance values are not the same across the three divisions of the International League of Triple-A minor league baseball. b. Use Fisher's LSD procedure to test whether there is a significant difference between the means for North (1), South (2), and West (3). Use a = .05. Absolute Value (to 2 decimals) LSD (to 2 decimals) Difference Conclusion 2158.58 O 1630.01 Significant difference 700.92 1630.01 No significant difference v T2 – T3 2859.50 O 2075.52 X Significant difference Check My Work Reset Problem
D
E
G
H.
M
P
R
T
Team Name
Division
L.
PCT
Attendance
Part a. Rearrange the Attendance values for the Anova: Single-Factor Analysis
Buffalo Bisons
North
66
77
0.462
8826
0.382
0.594
Lehigh Valley IronPigs
North
55
89
8506
North
South
West
North
North
Pawtucket Red Sox
85
58
9124
7716.83
5558.25
8417.75
Rochester Red Wings
74
70
0.514
6936
6
4
Scranton-Wilkes
Barre Yankees
North
88
56
0.611
7156
Syracuse Chiefs
Charlotte Knights
Durham Bulls
Norfolk Tides
Richmond Braves
Columbus Clippers
Indianapolis Indians
North
69
72
0.489
5753
4508
6986
6276
South
65
78
0.455
South
74
70
0.514
South
64
78
0.451
South
West
63
89
0.414
4463
69
73
0.486
7777
After reading these instructions delete all text in this shaded area.
West
68
76
0.472
8510
Louisville Bats
West
90
56
0.616
9127
Use the XLMiner Analysis ToolPak to conduct your Anova: Single Factor analysis.
Toledo Mud Hens
West
75
69
0.521
8257
After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (H16).
Your Anova analysis output should fit into this shaded area.
Part b
Significance Level (Alpha)
0.05
Formula
Critical t-value
#N/A
Fisher's LSD Procedure:
Conclusion
(Enter "Significant difference" or
"No significant difference"
Absolute Value
LSD
Absolute Value
LSD
Conclusion
North-South =ABS(H4-14)
North-West =ABS(H4-J4)
#N/A
#N/A
North-South
2158.58
700.92
#N/A
North-West
#N/A
Transcribed Image Text:D E G H. M P R T Team Name Division L. PCT Attendance Part a. Rearrange the Attendance values for the Anova: Single-Factor Analysis Buffalo Bisons North 66 77 0.462 8826 0.382 0.594 Lehigh Valley IronPigs North 55 89 8506 North South West North North Pawtucket Red Sox 85 58 9124 7716.83 5558.25 8417.75 Rochester Red Wings 74 70 0.514 6936 6 4 Scranton-Wilkes Barre Yankees North 88 56 0.611 7156 Syracuse Chiefs Charlotte Knights Durham Bulls Norfolk Tides Richmond Braves Columbus Clippers Indianapolis Indians North 69 72 0.489 5753 4508 6986 6276 South 65 78 0.455 South 74 70 0.514 South 64 78 0.451 South West 63 89 0.414 4463 69 73 0.486 7777 After reading these instructions delete all text in this shaded area. West 68 76 0.472 8510 Louisville Bats West 90 56 0.616 9127 Use the XLMiner Analysis ToolPak to conduct your Anova: Single Factor analysis. Toledo Mud Hens West 75 69 0.521 8257 After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (H16). Your Anova analysis output should fit into this shaded area. Part b Significance Level (Alpha) 0.05 Formula Critical t-value #N/A Fisher's LSD Procedure: Conclusion (Enter "Significant difference" or "No significant difference" Absolute Value LSD Absolute Value LSD Conclusion North-South =ABS(H4-14) North-West =ABS(H4-J4) #N/A #N/A North-South 2158.58 700.92 #N/A North-West #N/A
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Differential Equation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman