Tools › Finance and Business › Auditing › Benford's Law Test › Example
Benford's law on rows of id and book amount: a 1,200-line ledger that conforms
| Tool | Benford's Law Test |
| Source | original |
| Level | Professional |
Problem
A population of 1,200 invoices is pasted as rows of id and book amount with a header line, the layout the Audit Sampling tool reads. Name the amount column by its header and test the first digit, the second digit and the first two digits against Benford's law at the 5 % level.
Inputs to Enter
- Amounts: 1,200 seeded illustrative rows 'INV-0001, 354.95' and so on under the header 'id, book amount'; amount column: book amount; smallest amount 10
- Test in full: first two digits; significance level 5 %; no approval limit
Answers
- The amounts are read from column 2, named in the header line; the middle 90 % run from 51.89 to 12,863.83, 2.39 orders of magnitude
- First two digits: chi-square 73.26 on 89 degrees of freedom, p = 0.8862; mean absolute deviation 0.00208; 1 of 90 pairs beyond ±1.96 (pair 90, z = 1.98) where about 4.5 are expected by chance alone
- First digit: chi-square 12.29 on 8 degrees of freedom, p = 0.1386, with digits 2 and 1 beyond ±1.96 (digit 2: 244 amounts where 211.3 are expected, z = 2.44)
- Second digit: chi-square 1.62 on 9 degrees of freedom, p = 0.9961; no digit beyond ±1.96
Notes
Open this case in the tool: /analysis-tools/business/audit/benfords-law-test/?try=conforming-ledger. Seeded illustrative data (a lognormal ledger), no real company; checked against an independent numpy and scipy computation. Agreement with Benford's law does not show that entries are correct. Two first digits lie beyond the critical value although the test as a whole does not: single digits beyond it occur by chance.
More Examples for This Tool
- Benford's law, first two digits: 1,430 invoice amounts bunched just under a 5,000 approval limit
- Benford's law, first digit: 1,200 made-up amounts whose first digits are equally frequent
- When Benford's law does not apply: 600 rents within a narrow range
- Benford's law, second digit: round and repeated amounts in 903 expense claims