How To Calculate SMAPE Using Excel [3 Steps]

Calculate SMAPE Using Excel

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. SMAPE = (1/n) * Σ(|forecast – actual| / ((|actual| + |forecast|)/2) … Read more