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
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
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Trying to find the answers to the x's
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F52158ac4-32fe-4a00-98a5-494c4b1348b0%2F884c1516-d149-4e4b-ba62-abc0feee840c%2Fzwykwmo_processed.png&w=3840&q=75)
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
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F52158ac4-32fe-4a00-98a5-494c4b1348b0%2F884c1516-d149-4e4b-ba62-abc0feee840c%2Futgmyps_processed.png&w=3840&q=75)
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
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman