Weighted Moving Average Using Multiple Regression
1. Use Data Analysis from the attached excel file to create a multiple regression equation where the forecast for the next year is a function of the attendance in each of the previous 2 years. That is: F(t)=a + b1*D(t-1)+b2*D(t-2) Where: F is the forecast for period t a is the intercept bj is the regression coefficient