Exam 3 Practice (1).xlsx - Good Morning Students Today we will go over a practice test for your EXAM 3 on WEDNESDAY We Calculate three forecasts using

# Exam 3 Practice (1).xlsx - Good Morning Students Today we...

• 5

This preview shows page 1 - 3 out of 5 pages.

Good Morning Students, Today we will go over a practice test for your EXAM 3 on W 10 47 46.9 0.1 0.1 0.002128 Calculate three forecasts using the following data. First, for periods 4 through 10,develop the exponeforecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. Second, calculate the three-perforecast for periods 4 through 10. Third, calculate the weighted moving average for periods 4 through70, .20, and .10, with 0.70 applied to the most recent data. Calculate the mean absolute deviation (MApercent error (MAPE), and the cumulative sum of forecast error (CFE) for each forecasting procedure. procedure would you select? Why?
Day Week 1 Week 2 Sunday 289 260 1.089978 0.930946 1.010462 371.428571 Monday 150 125 0.565733 0.44757 0.506652 371.428571 Tuesday 160 145 0.603448 0.519182 0.561315 371.428571