Question: how to calculate weighted absolute percentage error?
Answer: Step 1: Enter the actual values and forecasted values in two separate columns. Step 2: Calculate the weighted error for each row. Recall that the weighted error is calculated as: |actual-forecast| / |actual| * 100 * actual.