Unit 5 Dropbox Assignment Answers by (Insert your name here)
In the summary tables below, insert only the answers. You will show work after the summary section.
Question 1
MAD
MSE
Question 2
a) Moving average forecast for year 13
b) Weighted moving average forecast for year 13
c) MAD for part a
d) MAD for part b
e) Recommended forecast method (justify):
Question 3
R-squared for Linear model
R-squared for polynomial model
Regression formula for linear model
Regression formula for polynomial model
Recommended forecast method (justify):
Work
Show all your work for the questions below.
Question 1
Show the errors you calculated.
Question 2
Show the two forecasts and the errors.
Question 3
Show the polynomial and linear trendline charts from Excel charting. Do not use multiple regressions for this question.