The **symmetric mean absolute percentage error (SMAPE) **is used to measure the predictive accuracy of models. It is calculated as:

**SMAPE** = (1/n) * Σ(|forecast – actual| / ((|actual| + |forecast|)/2) * 100

where:

**Σ**– a symbol that means “sum”**n**– sample size**actual**– the actual data value**forecast**– the forecasted data value

The smaller the value for SMAPE, the better the predictive accuracy of a given model.

The following step-by-step example explains how to calculate SMAPE in Excel.

**Step 1: Enter the Data**

First, we’ll enter some fake data for the actual sales and the forecasted sales during 12 consecutive sales periods for some company:

**Step 2: Calculate the SMAPE Differences**

Next, we’ll calculate the SMAPE difference for each sales period using the following formula:

**Step 3: Calculate SMAPE**

Lastly, we’ll use the following formula to calculate SMAPE:

The SMAPE for this particular model turns out to be **9.89**%.

**Additional Resources**

How to Calculate MAPE in Excel

How to Calculate MAE in Excel

How to Calculate RMSE in Excel