Question: how to calculate mean absolute percentage error in excel?
Answer: 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. ... 
Step 3: Calculate the mean absolute percent error.