The three techniques from Q3 are: Three month moving average, three month moving average with weights, and single exponential forecast.

Please show calculations for weights

Attendance at university basketball games is fairly consistent from year to year. The table below shows average attendance per game for each month of the 2019-20 season (no data for the 2020-21 season due to the university shut down for COVID). Month September October November December January February March Attendance per Game 350 500 450 575 650 700 625 Based on the data above, calculate the forecasts for attendance per game in each month of December - March, using the different methods below. Calculate the Mean Squared Error (MSE) for the forecasts made in December - March by the two techniques above AND the three techniques calculated in Question 3 from Assignment #1. Based on MSE calculations, which forecasting method is preferred and why? Using the preferred technique forecast the average sales per month for the following 2 months (April and May)