The Best Cities for NFL Gameday
To create the gameday index, firstly, the data for the cost of watching a game was gathered. This included prices for beer, soft drinks, hot dogs, parking, and tickets. These were all normalized and summed to give a total "Cost Index". As some costs are more important than others, it was necessary to weight them. All of the food indexes were given a weight of one. The parking was given a weight of three. The tickets were given a weight of five. Giving a total maximum score of 11.
After this data was gathered about the stadiums where people watch the game. Information was collected about the type of roof and the stadium capacity. Alongside this linkfluence was used to determine the number of positive posts on social media about the stadium from 7/1/2020 to 6/30/2021, to see whether or not visitors liked it.
This data was then normalized and summed to give a total "Stadium Index". Like the prices, the factors here were also weighted according to importance. The roof type had a weight of one, whereas the capacity and social media sentiment each had a weight of three. Giving a total maximum score of 7.
The final data table was then created to summarize this data. An extra index looking at the number of NFLL teams in the city was also added to this table. As more teams allow for a better opportunity to watch a good NFL game.
Following on from this the three indexes were then summed and ranked, to provide the final data set. The final score was out of 20.