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. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak X 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). The p-value is What is your conclusion? There is 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) (to 4 decimals). Difference F1-F₂ F₁-F3 F2-F3 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 LSD (to 2 decimals) Conclusion e Ⓒ Ⓒ
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. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak X 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). The p-value is What is your conclusion? There is 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) (to 4 decimals). Difference F1-F₂ F₁-F3 F2-F3 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 LSD (to 2 decimals) Conclusion e Ⓒ Ⓒ
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%
Transcribed Image Text:### Single-Factor ANOVA Analysis: Rearranging Attendance Data
#### Step-by-Step Guide to Single-Factor ANOVA Analysis Using Excel
**Data Overview**
We will use the attendance data of various baseball teams for conducting a Single-Factor ANOVA analysis. The data is structured as follows:
**Part a. Rearrange the Attendance Values for the ANOVA: Single-Factor Analysis**
| Team Name | Division | W | L | PCT | Attendance |
|---------------------------|----------|----|----|-------|------------|
| Buffalo Bisons | North | 66 | 77 | 0.462 | 8810 |
| Lehigh Valley IronPigs | North | 55 | 89 | 0.382 | 8497 |
| Pawtucket Red Sox | North | 85 | 58 | 0.594 | 9118 |
| Rochester Red Wings | North | 72 | 70 | 0.507 | 6934 |
| Scranton-Wilkes | North | 88 | 56 | 0.611 | 7137 |
| Barre Yankees | North | 60 | 74 | 0.483 | 5764 |
| Syracuse Chiefs | North | 88 | 56 | 0.611 | 7137 |
| Charlotte Knights | South | 68 | 70 | 0.466 | 4554 |
| Durham Bulls | South | 74 | 70 | 0.514 | 6966 |
| Norfolk Tides | South | 68 | 73 | 0.451 | 6291 |
| Richmond Braves | South | 63 | 83 | 0.432 | 4426 |
| Columbus Clippers | West | 79 | 63 | 0.556 | 7824 |
| Indianapolis Indians | West | 68 | 76 | 0.472 | 8550 |
| Louisville Bats | West | 89 | 56 | 0.614 | 9163 |
| Toledo Mud Hens | West | 75 | 69 | 0.521 | 8234 |
**Rearranging Data for ANOVA Analysis**
A visual
**Instructions:**
a. **Use α = .05 to test for any difference in the mean attendance for the three divisions.**
- **Calculate the value of the F-statistic (to 2 decimals).**
`________`
- **The p-value is** `________` **(to 4 decimals).**
- **What is your conclusion?**
There is `______` 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 α = .05.**
<table>
<tr>
<th>Difference</th>
<th>Absolute Value (to 2 decimals)</th>
<th>LSD (to 2 decimals)</th>
<th>Conclusion</th>
</tr>
<tr>
<td>\( \bar{x}_1 - \bar{x}_2 \)</td>
<td><input type="text"></td>
<td><input type="text"></td>
<td><input type="text"></td>
</tr>
<tr>
<td>\( \bar{x}_1 - \bar{x}_3 \)</td>
<td><input type="text"></td>
<td><input type="text"></td>
<td><input type="text"></td>
</tr>
<tr>
<td>\( \bar{x}_2 - \bar{x}_3](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc8514667-bf86-4079-a5fb-967fac7b38d7%2F25f0404a-2978-4f78-b0cf-048e5a2a8a1b%2F43u9srf_processed.png&w=3840&q=75)
Transcribed Image Text:---
### The International League of Triple-A Minor League Baseball Analysis
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.
**Note:** Due to a recent change by Microsoft, you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon.
[Open spreadsheet](link-to-spreadsheet)
**Instructions:**
a. **Use α = .05 to test for any difference in the mean attendance for the three divisions.**
- **Calculate the value of the F-statistic (to 2 decimals).**
`________`
- **The p-value is** `________` **(to 4 decimals).**
- **What is your conclusion?**
There is `______` 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 α = .05.**
<table>
<tr>
<th>Difference</th>
<th>Absolute Value (to 2 decimals)</th>
<th>LSD (to 2 decimals)</th>
<th>Conclusion</th>
</tr>
<tr>
<td>\( \bar{x}_1 - \bar{x}_2 \)</td>
<td><input type="text"></td>
<td><input type="text"></td>
<td><input type="text"></td>
</tr>
<tr>
<td>\( \bar{x}_1 - \bar{x}_3 \)</td>
<td><input type="text"></td>
<td><input type="text"></td>
<td><input type="text"></td>
</tr>
<tr>
<td>\( \bar{x}_2 - \bar{x}_3
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step 1: Write the given information.
VIEWStep 2: Perform the one way anova test using the excel.
VIEWStep 3: Determine the F statistics, P-value and conclusion.
VIEWStep 4: Determine the critical value, LSD differences for the Fisher's LSD procedure
VIEWStep 5: Compare absolute difference with Fisher's LSD procedure to test significant differences.
VIEWSolution
VIEW
Step by step
Solved in 6 steps with 13 images
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