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.