The symmetric cruel absolute proportion error (SMAPE) is worn to measure the predictive accuracy of fashions. It’s calculated as:
SMAPE = (1/n) * Σ(|forecast – original| / ((|original| + |forecast|)/2) * 100
the place:
- Σ – an emblem that suggests “sum”
- n – pattern measurement
- original – the original information worth
- forecast – the forecasted information worth
The smaller the price for SMAPE, the easier the predictive accuracy of a given type.
Refer to step by step instance explains how one can calculate SMAPE in Excel.
Step 1: Input the Knowledge
First, we’ll input some faux information for the original gross sales and the forecasted gross sales all through 12 consecutive gross sales classes for some corporate:
Step 2: Calculate the SMAPE Variations
Upcoming, we’ll calculate the SMAPE remaining for each and every gross sales duration the use of please see system:
Step 3: Calculate SMAPE
Finally, we’ll usefulness please see system to calculate SMAPE:
The SMAPE for this actual type seems to be 9.89%.
Backup Assets
Tips on how to Calculate MAPE in Excel
Tips on how to Calculate MAE in Excel
Tips on how to Calculate RMSE in Excel
