Table 1From “Forecast accuracy can hide offsetting errors”
The forecast-error cancellation trap
A zero mean signed error can hide a miss in every period when opposite errors cancel.
Table 1The forecast-error cancellation trap
| Period | Actual outcome | Forecast | Signed error | Absolute error |
|---|---|---|---|---|
| 1 | 100 | 80 | -20 | 20 |
| 2 | 100 | 120 | +20 | 20 |
| 3 | 100 | 80 | -20 | 20 |
| 4 | 100 | 120 | +20 | 20 |
| Mean | 100 | 100 | 0 | 20 |
Swipe or scroll horizontally if the table is wider than your screen.
Source: Author's synthetic example. Values are illustrative and do not describe an observed forecast set.

From the essay
Revenue operations & AI
Forecast accuracy can hide offsetting errors
A forecast can be unbiased on average while missing every period: keep signed error, absolute error, distribution, horizon, and decision cost separate.
Read the essayThis exhibit belongs to an essay: the numbers live here, the argument lives there.
Cite or embed
Related exhibits

Table 5Table
The row-level forecast-error audit
Forecast accuracy can hide offsetting errors

Table 1Table
What does sales forecasting mean before accuracy is summarized?
Forecast accuracy can hide offsetting errors

Table 4Table
Distribution matters before the mean
Forecast accuracy can hide offsetting errors
Contact
Bring the question you're working on.
Research, a guest lecture, or a commercial question.