1. Use DataAnalysis 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)
F is the forecast for period t
a is the intercept
bj is the regression coefficient for one period ago
D(t-j) is the attendance j periods ago for
I am requesting an explanation of why we need 2 variables for this equation and why I cannot run the regression with the current data set.
Thanks for selecting me as your expert. I’ve included …
The expert examines the weighted moving average using multiple regression analysis.