One of the most common metrics used to measure the forecasting accuracy of a model is **MAPE**, which stands for **mean absolute percentage error**.

The formula to calculate MAPE is as follows:

**MAPE** = (1/n) * Σ(|actual – forecast| / |actual|) * 100

where:

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

MAPE is commonly used because it’s easy to interpret and easy to explain. For example, a MAPE value of 11.5% means that the average difference between the forecasted value and the actual value is 11.5%.

The lower the value for MAPE, the better a model is able to forecast values. For example, a model with a MAPE of 2% is more accurate than a model with a MAPE of 10%.

**How to Calculate MAPE in Excel**

To calculate MAPE in Excel, we can perform the following steps:

**Step 1: Enter the actual values and forecasted values in two separate columns.**

**Step 2: Calculate the absolute percent error for each row.**

Recall that the absolute percent error is calculated as: |actual-forecast| / |actual| * 100. We will use this formula to calculate the absolute percent error for each row.

Column D displays the absolute percent error and Column E shows the formula we used:

We will repeat this formula for each row:

**Step 3: Calculate the mean absolute percent error.**

Calculate MAPE by simply finding the average of the values in column D:

The MAPE of this model turns out to be **6.47%**.

**A Note On Using MAPE**

Although MAPE is straightforward to calculate and easy to interpret, there are a couple potential drawbacks to using it:

**1. **Since the formula to calculate absolute percent error is |actual-forecast| / |actual| this means that it will be undefined if any of the actual values are zero.

**2. **MAPE should not be used with low volume data. For example, if the actual demand for some item is 2 and the forecast is 1, the value for the absolute percent error will be |2-1| / |2| = 50%, which makes it seem like the forecast error is quite high, despite the forecast only being off by one unit.

*Another common way to measure the forecasting accuracy of a model is MAD – mean absolute deviation. Read about how to calculate MAD in Excel here.*

**Additional Resources**

What is Considered a Good Value for MAPE?

How to Calculate SMAPE in Excel

How to Calculate MAE in Excel

Just wanted to say ‘thanks’ for publishing this explanation. As a layperson I found this super easy to follow and was exactly what I needed to assist with a planning project. Also used your pages for WMAPE & MAD. So… thanks! And keep up the great work!

Hi Zach,

If the actual is zero, should we considered it as blank in the average rows of MAPE Formula?

Thank you

Very helpful, thank you.

But assuming data actual data are give and months. Then how. Would you know the forecast data in other to perform perform you’re calculations?

It is very useful for me. Thank you very much.