FN-BESSELI-003: At large x the fixed recurrence start makes BESSELI badly wrong
Excel differs from the mathematical answer · measured · recorded 2026-11-04
Excel's recurrence for orders above 1 starts at a fixed j = 2*(n + int(sqrt(40*n))), which is far too low at large x. At x = 709.7 BESSELI of order 2 is 0.20% high, and order 3 is 53% low, where I3(709.7) is 2.4631E306. Orders 0 and 1, which use the polynomial and not the recurrence, are within about 1.6E-7 at the same x.
| Call and input route | Inputs | Excel | Correct value | Recorded in |
|---|---|---|---|---|
BESSELI(709.7, 3)cell-value2 | x: 709.70x40862d999999999an: 30x4008000000000000 | 1.1560227990465618e+3060x7f7a56f66ecd12a0 | 2.4631300544524576e+3060x7f8c0f97bbe572f6 | Excel 16.0 build 20527, Windows 64-bit, AMD Ryzen 7 4800H |
BESSELI(709.7, 2)cell-value2 | x: 709.70x40862d999999999an: 20x4000000000000000 | 2.4767103124440567e+3060x7f8c3732e70ce6f9 | 2.47182813908566e+3060x7f8c28f5d197b1dd | Excel 16.0 build 20527, Windows 64-bit, AMD Ryzen 7 4800H |
BESSELI(709.7, 0)cell-value2 | x: 709.70x40862d999999999an: 00x0000000000000000 | 2.4788083687166675e+3060x7f8c3d51558ee541 | 2.4788087273156452e+3060x7f8c3d519a191ac9 | Excel 16.0 build 20527, Windows 64-bit, AMD Ryzen 7 4800H |
Correct value: mpmath besseli at 800 bits, order the integer part of n, correctly rounded.
Correct value: mpmath besseli at 800 bits, order the integer part of n, correctly rounded.
Correct value: mpmath besseli at 800 bits, order the integer part of n, correctly rounded.
Basis: Readings at x = 709.7 for orders 0, 1, 2 and 3, compared with mpmath.
Inferred: That the fixed start is the cause is inferred: a binary64 transcription of the published body gives the same bits for orders 0, 2 and 3 at this x.
Open: How far the error extends at other x is not measured.
Evidence and capture sources
- DnaCalc-Research · round22-result.json 130ec21b3da03276c01fb27dce70463f08f90d9a · product; bank.own_BESSELI_gains research round 22 result
- DnaCalc-Research · evidence/round18/r16-published-score/observations.jsonl 2df115b9512d49c5d21cef02706b4616a130fe96 · line 177, id r16-besseli-021
- CalcFunc-Evidence · readings/excel-20527/BESSELI.json dec750f16294cb25a0bc00b90225b0eaeeb8d390 · r11-struct-besseli-09
- CalcFunc-Evidence · readings/excel-20527/BESSELI.json dec750f16294cb25a0bc00b90225b0eaeeb8d390 · r11-struct-besseli-01