SMAPE is also known as “Symmetric Mean Absolute Percentage Error”. It is used to predict the accuracy of measures on the basis of percentage error. In this tutorial, we are going to how we can calculate SMAPE in Excel with just 3 easy steps.
Table of Contents
SMAPE = (1/n) * Σ(|forecast – actual| / ((|actual| + |forecast|)/2) * 100
Above, you can see the formula of SMAPE that you can use while calculating symmetric mean absolute percentage error with hands.
After calculating if you get the smaller value then the predictive accuracy of data is said to be better.
You don’t have to be an expert to do this calculation. We’ve broken down the process into three easy steps so you can easily follow along.
Without further delay let’s jump into the step-by-step procedure of calculating SMAPE in excel.
1. Enter Actual and Forecasted values
In my case, I am using simple data. I have made 2 columns. Column B represents “Actual Values” and Column C represents “Forecasted Values”.
2. Find SMAPE Differences
Once you are done entering data, the next step is to find the SMAPE Difference
**you can use these applied formulas for your reference**
=ABS(C2-B2)/((ABS(B2)+ABS(C2))/2)
=ABS(C3-B3)/((ABS(B3)+ABS(C3))/2)
=ABS(C4-B4)/((ABS(B4)+ABS(C4))/2)
=ABS(C5-B5)/((ABS(B5)+ABS(C5))/2)
=ABS(C6-B6)/((ABS(B6)+ABS(C6))/2)
=ABS(C7-B7)/((ABS(B7)+ABS(C7))/2)
3. Find SMAPE
In the end, we are going to calculate the “Symmetric mean absolute percentage error”.
**you can use this applied formula for your reference**
=SUM(D2:D7)/COUNT(D2:D7)
As you can see we get the final value of 10.79% which is better.
You can calculate the SMAP of any model by just following the 3 simple steps in excel.
