BESSELI, BESSELJ functions return inaccurate result

demosfen 20 Reputation points
2025-03-10T08:12:20.1366667+00:00

BESSELI, BESSELJ functions return inaccurate result in compare to the results of other editors and libraries. For example results in excel:

=BESSELJ(1.9, 2) - 0.329925828669785

=BESSELI(1.5, 1) - 0.98166642847516605

But results in libreoffice, WolframAlpha and python scipy(https://docs.scipy.org/doc/scipy/reference/special.html) was different:

=BESSELJ(1.9, 2) - 0.329925727692387

=BESSELI(1.5, 1) - 0.9816664285779081

Why does the accuracy of the resulting differ and is this a bug or correct behaviour?

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

Accepted answer
  1. Jiajing Hua 18,060 Reputation points Moderator
    2025-03-11T02:42:13.7466667+00:00

    Hi @demosfen

    The differences in the results across different applications from the varying numerical methods and precisions. It’s not a bug, but a reflection of how each tool handles the computation.

    Similar thread: https://stackoverflow.com/questions/65592101/why-does-bessel-function-in-scipy-and-excel-give-different-results

    Thanks for your understanding.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.