You have taken a job as an analyst for Auburn University's ticket department. The marketing team is concerned that soaring concession prices will affect this year's football ticket sales. The manager believes that the rising prices in hotdogs and alcoholic drinks each year is slowly negatively impacting the number of fans going to the football games. You have been asked to provide data and visuals showing the relationship between the rising prices of concessions and the turnout of fans per game over the last 5 years. Create a chart that shows the gross margins that Auburn receives each game and determine whether the concession price increases are influencing ticket sales. Hint: It may be wise to also include winning / losing seasons due to less fans in the stadium per game.

Extra info:

Auburn Board provides ticket prices, season stats, and all revenue brought in each game Auburn home football games can have roughly 50,000 fans max.

Hot dogs are $15 and Alcoholic drinks are $20 In 2020, COVID - 19 resulted in a dramatic decrease in fans in the 2020 season.

Question

1) Devise your plan for solving the problem.

2) What needs to happen to / with the data in order to achieve your answers