Skip to content

Forecasting Methods Evaluation

Temporary Table

Summary Table

Moving Average with Window Size Optimization

See code for window size optimization

Exponential Smoothing with Alpha Value Optimization

See code for alpha value optimization


Seasonal Ratio

Step 1: Calculate CAGR

Seasonal Decomposition: Analyze the effectiveness of this method.
Step 3:

Step 2: Calculate seasonal indices per division

Step 3: Create forecast



Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.