Unit 6 Assignment (Read Carefully)
Unit 6 Dropbox Assignment Answers by (Insert your name here)
This template is only for the first part of the Assignment. See specific instructions in the Assignment for part 2.
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.