FN-GAMMA-001: Below 10, GAMMA is a stored product down to a seed on (1,2)
Detail for matching Excel's bits · measured · recorded 2026-11-04
With RN(v) meaning v rounded to 64 bits on the x87 unit and then stored to binary64, write x = i + y with GAMMA(1+y) on (1,2). For i from 2 to 9, GAMMA(x) is RN(t*GAMMA(1+y)), where t is the product (x-1)(x-2)...(1+y) taken from the top with each product RN. Each stage rounds, so the answers are not correctly rounded: at the fraction below, GAMMA(3.649...) is 1 unit high and GAMMA(5.649...) 1 unit low. The seed on (1,2) is a chain of stored products that has not been identified, and at x = 10 the route changes (FN-GAMMA-002).
| Call and input route | Inputs | Excel | Correct value | Recorded in |
|---|---|---|---|---|
GAMMA(1.6493607064491727)cell-value2 | number: 1.64936070644917270x3ffa63c80d581b40 | 0.9000202349725920x3fecccf73c5e41af | — | Excel 16.0 build 20527, Windows; bitness and CPU not recorded in this reading |
GAMMA(3.6493607064491727)cell-value2 | number: 3.64936070644917270x400d31e406ac0da0 | 3.93286472358567040x400f7681c7bb23e9 | 3.932864723585670x400f7681c7bb23e8 | Excel 16.0 build 20527, Windows; bitness and CPU not recorded in this reading |
GAMMA(5.649360706449173)cell-value2 | number: 5.6493607064491730x401698f2035606d0 | 66.729679811456080x4050aeb312f3b057 | 66.72967981145610x4050aeb312f3b058 | Excel 16.0 build 20527, Windows; bitness and CPU not recorded in this reading |
Correct value: mpmath gamma at 800 bits from the binary64 input, correctly rounded.
Correct value: mpmath gamma at 800 bits from the binary64 input, correctly rounded.
Basis: 2,000 of 2,000 fractions at each i from 2 to 9, from Excel's own GAMMA(1+y) (build 20527). The same formula fails at i = 10. Replayed for this note in exact rational arithmetic on 300 of those fractions: 300 of 300 at each i from 2 to 9, 61 of 300 at i = 10. Recorded GAMMA rows match 6,406 of 12,603 with stand-ins for the seed and the Stirling series, the worst by 49 units.
Open: The seed GAMMA(1+y) on (1,2): about five stored smooth quantities, seen as lines in its noise. Cody's rational matches 33% of it. Many closed families were tested and refuted.
Open: x < 1 and negative arguments.
Evidence and capture sources
- ExcelFunctionsHandbook · content/notes/evidence/2026-11-04/gamma-EVIDENCE.md b5d84a80a5a4640eca9ce04f232c0bc115503f34 · research write-up: how the stored stages were read
- DnaCalc · crates/calc-func/src/ported/excel_numeric/gammaln.rs 1c7a4ab86b12b53d80947f06b6d381e8e5dd5f3f · the routes in the product, with stand-ins where the code says so; the commit message carries the row counts
- DnaCalc · crates/calc-func/witness-status.tsv af74247e1ed54f0b535143f1305261b98d80d18e · rows matched per function
- ExcelFunctionsHandbook · content/notes/evidence/2026-11-04/gamma-readings.tsv b5d84a80a5a4640eca9ce04f232c0bc115503f34 · GAMMA 3ffa63c80d581b40
- ExcelFunctionsHandbook · content/notes/evidence/2026-11-04/gamma-readings.tsv b5d84a80a5a4640eca9ce04f232c0bc115503f34 · GAMMA 400d31e406ac0da0
- ExcelFunctionsHandbook · content/notes/evidence/2026-11-04/gamma-readings.tsv b5d84a80a5a4640eca9ce04f232c0bc115503f34 · GAMMA 401698f2035606d0