Midwestern College is experiencing increased attendance at their home football games. Attendance prior to 2007 averaged 27000 per game. The table below lists attendance for the past six years. The second game of each season is the homecoming game. The fourth game of each season is during the locally sponsored Arts & Crafts Festival.
The existing stadium has seating for 54000. The athletic director is convinced it is time to build a new stadium and has asked you to analyze the data and make a recommendation. Taking into account the seasonality of the games forecast attendance at each game (1-5) for the next 5 years and make a recommendation regarding when a new stadium should be built (ie what game in what year will forecasted attendance exceed capacity).
2007 2008
Game
Attendance
Opponent
Game
Attendance
Opponent
1
34200
Whitman
1
36100
ISU
2
39800
Wayne State
2
40200
Duke
3
38200
Reed
3
39100
Anaheim
4
26900
Gonzaga
4
25300
Western
5
35100
Northeastern
5
36200
Pendleton
2009 2010
Game
Attendance
Opponent
Game
Attendance
Opponent
1
35900
Atlantic
1
41900
Montreal
2
46500
Wayne State
2
46100
Toronto
3
43100
Reed
3
43900
St. Clair
4
27900
Whitman
4
30100
Pacific
5
39200
Green Bay
5
40500
Northeastern
2011 2012
Game
Attendance
Opponent
Game
Attendance
Opponent
1
42500
NOVA
1
46900
Northeastern
2
48200
Westminster
2
50100
Whitman
3
44200
Abercrombie
3
45900
Reed
4
33900
Eastern
4
36300
Gonzaga
5
47800
Reed
5
49900
Wayne State
Attachments: