Business Analytics - Forecasting
Veedish
assignment_template.docxUnit 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.
ANSWER TO THE BONUS QUESTION
“the simplest way you can come up with a forecast is called ___”
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.
