What would you like to understand?

Because the recursive formula needs a previous forecast, the video demonstrates a simple initialization method: set the first forecast equal to the first actual observation. In the example this gives $F(1)=A(1)=1103$.

Conditions: Applies when no earlier forecast is available.; Shown specifically for Week 1 in the example.

Because the recursive formula needs a previous forecast, the video demonstrates a simple initialization method: set the first forecast equal to the first actual observation. In the example this gives $F(1)=A(1)=1103$.

Conditions: Applies when no earlier forecast is available.; Shown specifically for Week 1 in the example.

The video translates the mathematical recurrence into an Excel formula. For Week 2, the current forecast is computed from the Week 1 forecast in C4, the Week 1 actual in B4, and the smoothing constant in B2.

Conditions: Requires a table with actuals in one column and forecasts in another.; Uses relative references for prior row values and an absolute reference for alpha.

The video translates the mathematical recurrence into an Excel formula. For Week 2, the current forecast is computed from the Week 1 forecast in C4, the Week 1 actual in B4, and the smoothing constant in B2.

Conditions: Requires a table with actuals in one column and forecasts in another.; Uses relative references for prior row values and an absolute reference for alpha.