Team Name Division W L PCT Attendance Buffalo Bisons North 66 77 0.462 8818 Lehigh Valley IronPigs North 55 89 0.382 8475 Pawtucket Red Sox North 85 58 0.594 9112 Rochester Red Wings North 77 70 0.524...





























































































































Team NameDivisionWLPCTAttendance
Buffalo BisonsNorth66770.4628818
Lehigh Valley IronPigsNorth55890.3828475
Pawtucket Red SoxNorth85580.5949112
Rochester Red WingsNorth77700.5246910
"Scranton-Wilkes Barre Yankees"North88560.6117172
Syracuse ChiefsNorth69730.4865742
Charlotte KnightsSouth65780.4554554
Durham BullsSouth74700.5147013
Norfolk TidesSouth64780.4516272
Richmond BravesSouth63880.4174435
Columbus ClippersWest69730.4867768
Indianapolis IndiansWest68760.4728561
Louisville BatsWest85560.6039171
Toledo Mud HensWest75690.5218225


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

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







  1. Use 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.




  2. 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 .






























    Difference

    Absolute Value

    (to 2 decimals)

    LSD

    (to 2 decimals)

    Conclusion















Jun 02, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here