Answer the following questions using the data from the Excel file daily customers. xlsx described in Problem

Question:

Answer the following questions using the data from the Excel file daily customers. xlsx described in Problem 16.38:
Answer the following questions using the data from the Excel

a. Forecast the number of customers who will visit Dave€™s store on Day 9 using a two period weighted moving average with the weights 5 and 2.
b. Calculate the MAD for the forecast in part a.
c. Forecast the number of customers who will visit Dave€™s store on Day 9 using exponential smoothing with trend adjustment and setting α = 0.1 and β = 0.3.
d. Calculate the MAD for the forecast in part c.
e. In which forecast do you have the most confidence?

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: