Answer the following questions using the data from the Excel file Deloitte. xlsx from Problem 16.36. From

Question:

Answer the following questions using the data from the Excel file Deloitte. xlsx from Problem 16.36.
From Problem
Answer the following questions using the data from the Excel

a. Using exponential smoothing with α = 0.6, forecast the percentage of holiday shoppers who intend to spend less in 2013.
b. Calculate the MAD for the forecast in part a.
c. Using exponential smoothing with trend adjustment, α = 0.6 and β = 0.4, forecast the percentage of holiday shoppers who intend to spend less in 2013.
d. Calculate the MAD for the forecast in part c.
e. Which forecast do you have most confidence in?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics

ISBN: 9780321925121

2nd Edition

Authors: Robert A. Donnelly

Question Posted: