The International League of Triple-A minor league baseball consists of 14 teams organized into three divisions:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Tool Pak 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). 6.86 The p-value is .0116 What is your conclusion? There is sufficient (to 4 decimals). 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. Absolute Value LSD (to 2 decimals) Difference (to 2 decimals) - 2134.42 1634.38 1-3 735.33 1634.38 2-3 2869.75 1634.38 Conclusion Significant difference No significant difference Significant difference Check My Work Reset Problem D E G Team Name Division W Buffalo Bisons North 66 Lehigh Valley IronPigs North 55 Pawtucket Red Sox North 85 Rochester Red Wings North 71 Scranton-Wilkes Barre Yankees North 88 Syracuse Chiefs North 69 Charlotte Knights South 61 Durham Bulls South 74 Norfolk Tides South 64 Richmond Braves South 63 Columbus Clippers West 69 Indianapolis Indians West 68 Louisville Bats West 87 Toledo Mud Hens West 75 LTP PPPPPLES PCT Attendance Part a. Rearrange the Attendance values for the Anova: Single-Factor Analysis 77 0.462 8808 89 0.382 8456 North South West 58 0.594 9103 8808 4497 7775 70 0.504 6913 8456 7020 8558 56 0.611 7118 9103 6284 9149 74 0.483 5758 6913 4432 8230 78 0.439 4497 7118 70 0.514 7020 5758 78 0.451 6284 78 0.447 4432 73 0.486 7775 Anova: Single Factor 76 0.472 8558 56 0.608 9149 SUMMARY 69 0.521 8230 Groups North South West Count Sum 6 4 4 33712 Average Variance 46156 7692.6667 1699348.7 22233 5558.25 1686038.9 8428 334118 MS F P-value F crit 2 9074365.4 6.8569452 0.0116542 3.982298 11 1323383.1 ANOVA Source of Variation SS df Between Groups Within Groups 18148730.85 14557214.08 Total 32705944.93 13 Part b Significance Level (Alpha) Critical t-value Fisher's LSD Procedure: North-South North-West South-West 0.05 2.2010 Formula |=T.INV.2T(131,J24) Conclusion (Enter "Significant difference" or "No significant difference" 1634.38 Significant Difference 1634.38 No Significant Difference 1634.38 Significant Difference Absolute Value North-South ABS(K16-K17) North-West ABS(K16-K18) South-West ABS(K17-K18) LSD Conclusion =$I$33 * SQRT($K$24 * (1/$I$16 + 1/$I$1 =IF(137>=J37,"Significant Difference", "No Significant Differer =$I$33 * SQRT($K$24 * (1/$I$16 + 1/$I$1]=IF(138>=J38,"Significant Difference","No Significant Differer =$I$33 * SQRT($K$24 * (1/$I$16 + 1/$I$1 =IF(139>=J39,"Significant Difference","No Significant Differer Absolute Value LSD 2134.42 735.33 2869.75 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 Tool Pak 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). 6.86 The p-value is .0116 What is your conclusion? There is sufficient (to 4 decimals). 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. Absolute Value LSD (to 2 decimals) Difference (to 2 decimals) - 2134.42 1634.38 1-3 735.33 1634.38 2-3 2869.75 1634.38 Conclusion Significant difference No significant difference Significant difference Check My Work Reset Problem D E G Team Name Division W Buffalo Bisons North 66 Lehigh Valley IronPigs North 55 Pawtucket Red Sox North 85 Rochester Red Wings North 71 Scranton-Wilkes Barre Yankees North 88 Syracuse Chiefs North 69 Charlotte Knights South 61 Durham Bulls South 74 Norfolk Tides South 64 Richmond Braves South 63 Columbus Clippers West 69 Indianapolis Indians West 68 Louisville Bats West 87 Toledo Mud Hens West 75 LTP PPPPPLES PCT Attendance Part a. Rearrange the Attendance values for the Anova: Single-Factor Analysis 77 0.462 8808 89 0.382 8456 North South West 58 0.594 9103 8808 4497 7775 70 0.504 6913 8456 7020 8558 56 0.611 7118 9103 6284 9149 74 0.483 5758 6913 4432 8230 78 0.439 4497 7118 70 0.514 7020 5758 78 0.451 6284 78 0.447 4432 73 0.486 7775 Anova: Single Factor 76 0.472 8558 56 0.608 9149 SUMMARY 69 0.521 8230 Groups North South West Count Sum 6 4 4 33712 Average Variance 46156 7692.6667 1699348.7 22233 5558.25 1686038.9 8428 334118 MS F P-value F crit 2 9074365.4 6.8569452 0.0116542 3.982298 11 1323383.1 ANOVA Source of Variation SS df Between Groups Within Groups 18148730.85 14557214.08 Total 32705944.93 13 Part b Significance Level (Alpha) Critical t-value Fisher's LSD Procedure: North-South North-West South-West 0.05 2.2010 Formula |=T.INV.2T(131,J24) Conclusion (Enter "Significant difference" or "No significant difference" 1634.38 Significant Difference 1634.38 No Significant Difference 1634.38 Significant Difference Absolute Value North-South ABS(K16-K17) North-West ABS(K16-K18) South-West ABS(K17-K18) LSD Conclusion =$I$33 * SQRT($K$24 * (1/$I$16 + 1/$I$1 =IF(137>=J37,"Significant Difference", "No Significant Differer =$I$33 * SQRT($K$24 * (1/$I$16 + 1/$I$1]=IF(138>=J38,"Significant Difference","No Significant Differer =$I$33 * SQRT($K$24 * (1/$I$16 + 1/$I$1 =IF(139>=J39,"Significant Difference","No Significant Differer Absolute Value LSD 2134.42 735.33 2869.75
Expert Answer:
Posted Date:
Students also viewed these mathematics questions
-
Exam scores of 40 students in a statistics class are shown. (a) Estimate the mean and standard deviation from the sample. (b) Assuming that the data are from a normal distribution, de ne bins by...
-
This is the third year audit of Green Lawns. The company has carved out a new market niche on the Web for the delivery of lawn and garden supplies, including links with local companies that provide...
-
Use the Internet to locate the financial statements (and associated audit report) of one company reporting using U.S. accounting standards and another company reporting using international accounting...
-
What is meant by a confidence interval for a regression line? Compare in concept the confidence interval for regression analysis and for variables sampling.
-
California Cars is a U. S. manufacturer of electric cars. California Cars has $ 5 billion of U.S. taxable income$ 4 billion of which is U.S.- source income and $ 1 billion of which is foreign- source...
-
Can an airport sponsor create excessive revenue surpluses? Explain and include a discussion about what action the FAA might take if it discovers this practice.
-
A client weighs 201 lb (91.5 kg) and has a maximum aerobic power of 40.7 ml/kg/min. What exercise intensity (power output) on a cycle ergometer will enable him to maintain a target training intensity...
-
Explain what laws/regulations can be used or applied to these people if they decide to file a discrimination complaint for not being accepted in a job because of their gender and age?
-
Lehigh University is planning to issue 5 year bonds with a face value of $50,000 on January 1, 2016. The coupon or stated rate for the bond is 10% and is paid quarterly. The market rate for similar...
-
Gelay J. 35 y.o. was admitted to Benguet General Hospital for shortness of breath, weakness, productive cough, chest pains and epigastric discomfort. Vital signs upon admission were: T- 38.2 C, P-...
-
An electronic line judge camera captures the impact of a 5 7 . 0 - g tennis ball traveling at 3 0 m / s with the side line of a tennis court. The ball rebounds with a speed of 2 1 . 4 m / s and is...
-
1. what do you think about P&G's approach to innovation and product development? 2. Questions on P&G company.
-
You are an auditor in Smit & Chandra, a mid-tier audit firm. Your firm is the incumbent auditor on Biotech Ltd, a pharmaceutical company. Since the previous audit, the company has listed on the...
-
What exactly is a prima facie duty? How does an ethic of prima facie duties differ from monistic and absolutist ethical theories?
Study smarter with the SolutionInn App