NEED NUMBER 2!

**the 'Actual' data for Question 3 is mislabeled. It should be data for the two seasons you created a forecast for in Question 2, which would be the 2022 and 2023 seasons**

Southwestern University Football Game Attendance, 2016-2021 Solution Requirements Jtilize Microsoft Excel to complete the following steps: 1. Create a linear trend forecast for the next ten games. Hint: You will have to create a linear trend equation for each game of the season across all six years. In other words, use all six years of info for Game 1 to create a Game 1 trend equation. Then repeat for Game 2 through Game 5. Once you have the equation for each of the five games, a forecast can be made for each game across the next two years to give you ten game forecasts. For example: 2. Compute seasonal indices for each game. Use this to adjust the linear trend forecast generated in the previous step for the next ten games. Hint: Use games as "seasons," with the six years of data for each season. 3. Calculate the MAD, MSE, and MAPE. Assume the actual demand for the next ten games is: 4. Use the forecast and information in the case on ticket prices to project revenue for the next two seasons