Unit 6 Business analytics
Unit 6 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 regression analysis for this question.