Unit 5: Assignment

profileqtavnf10901
unit_5_assignment_template.docx

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.