How far off?
A signed difference tells you which way the result moved, as well as how much.
For numbers that are not on speaking terms
Expected one thing. Got another. Find the gap without opening a spreadsheet and pretending you remember the formula.
Compare two numbers ↓Free to use. No account. Your input stays in your browser.
A signed difference tells you which way the result moved, as well as how much.
Percentages need a baseline. Zero cannot be used as a divisor, no matter how confidently it dresses.
The calculation runs here in your browser. Your numbers do not need a cloud meeting.
A very small number investigation
Enter expected and actual values in that order. We show actual minus expected, and change relative to the absolute expected value.
Compare up to 50 rows offline in a free spreadsheet. Five editable examples use the same signed difference and absolute-baseline formula as this calculator.
Download the expected vs actual worksheet (.xlsx)
No macros, external data connections or sign-up. Keep units and periods consistent. MIT licence permits reuse and adaptation.
Read, then try
Learn the signed difference and percentage calculation used by Discrepan.si, with worked examples and a clear expected-value baseline.
See how the discrepancy calculator handles a zero expected value and negative baselines, with worked examples that match its absolute-baseline formula.
Good ideas welcome
Suggest a collaboration, share feedback, or enquire about acquiring this website and domain.
The enquiry service is being connected. Please check back soon.