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.88 The p-value is 0.0115 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) 2121.08 LSD Difference (to 2 decimals) Conclusion Significant difference 731.17 No significant difference vO 2852.25 Significant difference Check My Work Reset Problem
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.88 The p-value is 0.0115 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) 2121.08 LSD Difference (to 2 decimals) Conclusion Significant difference 731.17 No significant difference vO 2852.25 Significant difference Check My Work Reset Problem
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
100%
THESE ARE NOT GRADED, THE GREEN AND RED MARKS COME FROM ME HITTING CHECK MY WORK AS I AM WORKING ON THE PROBLEM, STOP REJECTING MY QUESTION FOR THIS BECAUSE I RESUBMIT AND THEY GET ANSWERED!!
Transcribed Image Text:13.2 Excel Activity 1 - F-Test, Fisher's LSD Procedure (Structured)
Question 1
5/10
Video
Submit
The International Leaque 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.88
The p-value is 0.0115
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
Difference
(to 2 decimals)
Conclusion
T1 - 72
2121.08
Significant difference
731.17
No significant difference v
2852.25
Significant difference
Check My Work
Reset Problem
Transcribed Image Text:9153
Barre Yankees
Syracuse Chiefs
Charlotte Knights
North
88
56
0.611
7127
9094
6270
North
69
72
0.489
5776
6884
4482
8210
South
64
78
0.451
4519
7127
Durham Bulls
South
74
70
0.514
7018
5776
Norfolk Tides
South
0.451
0.457
64
78
6270
Richmond Braves
South
63
75
4482
Columbus Clippers
Indianapolis Indians
Louisville Bats
West
69
73
0.486
7789
Anova: Single Factor
West
68
76
0.472
8546
West
85
56
0.603
9153
SUMMARY
Toledo Mud Hens
West
75
69
0.521
8210
Groups
North
Count
Sum
Average
46160 7693.3333 1691412.7
Variance
6.
South
4
22289
5572.25 1625009.6
West
33698
8424.5 331781.67
ANOVA
Source of Variation
SS
df
MS
P-value
F crit
Between Groups
Within Groups
17926547.27
2 8963273.6 6.8816223 0.0115271
3.982298
14327437.08
11 1302494.3
Total
32253984.36
13
Part b
Significance Level (Alpha)
0.05
Formula
Critical t-value
0.9610
=T.DIST.2T(131,J24)
Fisher's LSD Procedure:
Conclusion
(Enter "Significant difference" or
"No significant difference"
Absolute Value
LSD
Absolute Value
LSD
=SIS33*SQRT(SK$24*(1/SIS16+1/SIS 17)) #N/A
=SIS33*SQRT(SK$24*(1/SIS16+1/SIS18)) #N/A
=$I$33*SQRT(SK$24*(1/SIS17+1/SIS18)) #N/A
North-South
2121.08
707.97
707.97
775.54
North-South =ABS(K16-K17)
North-West =ABS(K16-K18)
South-West =ABS(K17-K18)
North-West
731.17
South-West
2852.25
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
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
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman