how to calculate weighted absolute percentage error?
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.