Calculate Three Forecasts Using the Following Data

question 58

Essay

Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F₃) of 45.0 and an alpha of 0.4. Second, calculate the three-period moving-average forecast for periods 4 through 10. Third, calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data. Calculate the mean absolute deviation (MAD) and the cumulative sum of forecast error (CFE) for each forecasting procedure. Which forecasting procedure would you select? Why?

---

Definitions:

Promote

To elevate the priority or visibility of a particular item, idea, or website, often through marketing or algorithmic adjustments.

Demote

The process of reducing an item's rank or position within a hierarchical structure, such as in an organization or a document outline.

Odd Page

A page in a document that is numbered with an odd number, typically found on the right side when printed and bound.

Section Break

A feature in word processing software that allows users to divide documents into sections, each with its own layout and formatting settings.