Within this clip, the setup is completed through the Week 2 formula and the recursion pattern for later weeks is explained; the numerical Week 11 forecast is not yet computed on screen.
Conditions: The clip ends after demonstrating the Week 2 formula entry.; The goal stated at the beginning is to find the Week 11 forecast.
Within this clip, the setup is completed through the Week 2 formula and the recursion pattern for later weeks is explained; the numerical Week 11 forecast is not yet computed on screen.
Conditions: The clip ends after demonstrating the Week 2 formula entry.; The goal stated at the beginning is to find the Week 11 forecast.
The chart legend distinguishes observed sales from model-generated forecasts by color. The blue line is Unit Sales and the red line is Forecast, so the visual effect of exponential smoothing can be seen as forecasts are added week by week.
Conditions: The chart is linked to the Excel table containing both actual and forecast columns.; Colors are assigned consistently in the legend.
The chart legend distinguishes observed sales from model-generated forecasts by color. The blue line is Unit Sales and the red line is Forecast, so the visual effect of exponential smoothing can be seen as forecasts are added week by week.
Conditions: The chart is linked to the Excel table containing both actual and forecast columns.; Colors are assigned consistently in the legend.