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 2

a)   Moving average forecast for year 13

Weighted moving average forecast for year 13

MAD for part a

MAD for part b

Recommended forecast method (justify):

Work

Show all your work for the questions below. Make sure to also attach your Excel file to avoid losing points

Question 1

Show the errors you calculated.

Question 2

Show the two forecasts and the errors Copy and paste the entire forecast table from Excel.

Question 3

Show the polynomial and linear trendline charts from Excel charting. Do not use multiple regression analysis for this question or you will lose points.