Midwestern College is experiencing increased attendance at their home football games
tutor4helpyouMidwestern College is experiencing increased attendance at their home football games. Attendance prior to 2007 averaged 27,000 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 54,000. 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 | 34,200 | Whitman |
| 1 | 36,100 | ISU |
2 | 39,800 | Wayne State |
| 2 | 40,200 | Duke |
3 | 38,200 | Reed |
| 3 | 39,100 | Anaheim |
4 | 26,900 | Gonzaga |
| 4 | 25,300 | Western |
5 | 35,100 | Northeastern |
| 5 | 36,200 | Pendleton |
2009 2010
Game | Attendance | Opponent |
| Game | Attendance | Opponent |
1 | 35,900 | Atlantic |
| 1 | 41,900 | Montreal |
2 | 46,500 | Wayne State |
| 2 | 46,100 | Toronto |
3 | 43,100 | Reed |
| 3 | 43,900 | St. Clair |
4 | 27,900 | Whitman |
| 4 | 30,100 | Pacific |
5 | 39,200 | Green Bay |
| 5 | 40,500 | Northeastern |
2011 2012
Game | Attendance | Opponent |
| Game | Attendance | Opponent |
1 | 42,500 | NOVA |
| 1 | 46,900 | Northeastern |
2 | 48,200 | Westminster |
| 2 | 50,100 | Whitman |
3 | 44,200 | Abercrombie |
| 3 | 45,900 | Reed |
4 | 33,900 | Eastern |
| 4 | 36,300 | Gonzaga |
5 | 47,800 | Reed |
| 5 | 49,900 | Wayne State |
12 years ago
Purchase the answer to view it
answer.docx- data.xlsx
