Question

The International League of Triple-A minor league baseball consists of 14 teams organized into three divisions: North, South, and West. The following data show the average attendance for the 15 teams in the International League. 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. A test for any difference in the mean attendance for the three divisions has been requested.

1. Explicitly state and conduct the appropriate hypothesis test to determine if any significant difference in the mean number people in attendance by division. (All steps should be included)
2. Present a graph that summarizes the data along with a table of summary statistics for each variable in the data set. An interpretation must accompany any graph, chart, or table that you use.

   Team Name	Division	W	L	PCT	Attendance
   Buffalo Bisons	North	66	77	0.462	8812
   Lehigh Valley IronPigs	North	55	89	0.382	8479
   Pawtucket Red Sox	North	85	58	0.594	9097
   Rochester Red Wings	North	74	70	0.514	6913
   Scranton-Wilkes Barre Yankees	North	88	56	0.611	7147
   Syracuse Chiefs	North	69	73	0.486	5765
   Charlotte Knights	South	63	78	0.447	4526
   Durham Bulls	South	74	70	0.514	6995
   Nashville Sounds	South	72	68	0.514	8823
   Norfolk Tides	South	64	78	0.451	6286
   Richmond Braves	South	63	78	0.447	4455
   Columbus Clippers	West	69	73	0.486	7795
   Indianapolis Indians	West	68	76	0.472	8538
   Louisville Bats	West	88	56	0.611	9152
   Toledo Mud Hens	West	75	69	0.521	8234

Answer 1

Explicitly state and conduct the appropriate hypothesis test to determine if any significant difference in the mean number people in attendance by division. (All steps should be included)

1. Arrange the data in excel as shown.

2. Under the data analysis tab use the one-way anova.

3. Input the value as shown.

4. The output will be generated as follows.

Hypothesis:

H0: The mean attendance in the three division is equal.
H1: The mean attendance in the three division is not equal.

From the anova output we look at the pvalue = 0.0820 (highlighted in yellow)

Since the pvalue is greater than 0.05, we fail to reject the null hypothesis and conclude that the mean attendance in the three division is equal.

Present a graph that summarizes the data along with a table of summary statistics for each variable in the data set. An interpretation must accompany any graph, chart, or table that you use.

The summary statistics and graphs are given below.