Documentation/Calc Functions/BESSELI
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
BESSELI
Category:
Add-in
Summary:
Calculates the value of a modified Bessel function of the first kind, usually referred to as In(x). n is the order of the function and x is the value at which the function is to be calculated.
Syntax:
BESSELI(X; N)
Returns:
Returns a real number which is the value of the modified Bessel function of the first kind, with a specified order, for a given value of x.
Arguments:
X is a real number, or a reference to a cell containing that number, which is the value at which the modified Bessel function of the first kind is to be calculated.
N is a non-negative integer, or a reference to a cell containing that number, which is the order of the modified Bessel function of the first kind.
- If either X or N is non-numeric, then BESSELI reports a #VALUE! error.
- If N is a non-integer value, then BESSELI truncates it to an integer.
- If N is negative, then BESSELI reports an invalid argument error (Err:502).
Additional details:
Details specific to BESSELI function
The following figure shows a plot of the modified Bessel functions of the first kind for orders 0, 1, 2, and 3.
Modified Bessel functions of the first kind are finite at the origin, x = 0. They exhibit odd or even parity depending on the order of the function, so that In(-x) = In(x) for even orders and In(-x) = -In(x) for odd orders.
ODF 1.2 indicates that the first argument to the BESSELI function should be an integer. However, this is considered an unnecessary limitation and Calc’s implementation caters for real values of X.
General information about Calc's Bessel functions
 |
Note:
|
Calc provides two Bessel functions that are solutions of Bessel's differential equation and two modified Bessel functions that are solutions of the modified Bessel equation. The mathematics behind these equations and functions is beyond the scope of this wiki but more information can be found at Wikipedia’s Bessel function page and in the sources that it references.
The four functions provided by Calc are as follows:
- BESSELJ – calculates values of Jn(x), a Bessel function of the first kind, for non-negative integer vales of n.
- BESSELY – calculates values of Yn(x), a Bessel function of the second kind, for non-negative integer vales of n and positive values of x.
- BESSELI – calculates values of In(x), a modified Bessel function of the first kind, for non-negative integer vales of n.
- BESSELK - calculates values of Kn(x), a modified Bessel function of the second kind, for non-negative integer vales of n and positive values of x.
In each case the parameter n is known as the order of the function.
Examples:
| Formula | Description | Returns |
|---|---|---|
| =BESSELI(3.45; 4) | Here the function calculates the value of the modified Bessel function of the first kind, with order 4, at an x value of 3.45. | 0.651416873060081 |
| =BESSELI(3.45; 4.333) | Here the function calculates the value of the modified Bessel function of the first kind, with order 4.333, at an x value of 3.45. The result is the same as in the previous example, showing that Calc truncates the value of 4.333 to 4. | 0.651416873060081 |
| =BESSELI(−3.45; 4) | Here the function calculates the value of the modified Bessel function of the first kind, with order 4, at an x value of -3.45. The result is the same as in the previous examples, showing that for an even order, the function is even. | 0.651416873060081 |
| =BESSELI(H1; H2) where cells H1 and H2 contain the values 2.6 and 3 respectively. | Here the function calculates the value of the modified Bessel function of the first kind, with order 3, at an x value of 2.6. | 0.549626665934213 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
BESSELI