What is Multiple Regression?

The model to be fit using regression is

Using the data provided on the excel worksheet, multiple regression analysis was conducted. Since the p-values for each coefficient were all well below 0.05, the model was determined to have the following coefficients and constant:

For month 21,

Therefore,

From the above model, there appears to be a problem with the autocorrelation of the residuals.

References

Using Multiple Regression in Excel for Predictive Analysis. (2013). Retrieved 5 September 2019, from https://www.youtube.com/watch?v=HgfHefwK7VQ&t=275s 

Academy, J. (2015). Multiple Regression in Excel. Retrieved 5 September 2019, from https://www.youtube.com/watch?v=cXiZ_t2NK1k