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.