Data-Tool Excel Add-ins

CDF/PDF, Matrix, Correlation Graph
Reshape Data, Daily to Monthly etc.
Trend Test and MLR.

MAPE (Mean Absolute Percentage Error)

The mean absolute percentage error (MAPE), also referred to as mean absolute percentage deviation (MAPD), serves as a statistical measure to assess the accuracy of a forecasting method, often employed in trend estimation within statistics and as a loss function in regression problems in Machine Learning. MAPE quantifies the magnitude of error in percentage terms, offering insight into the predictive performance of a model. It is computed as the average of the unsigned percentage errors, as demonstrated in the formula below:

Mean Absolute Percentage Error

Where Obsi represents the observed value and Modeli denotes the forecast value for each data point i. The MAPE provides a standardized measure of prediction accuracy, allowing for comparisons across different forecasting models or techniques.

How To Cite

Please provide the data in a two-column format (observed vs. simulated). You can copy from Excel, text, or any other format, separated by space.

Mean Absolute Percentage Error: %

Help Video:

Video Thumbnail