BESSELK Excel Formula

Author Zaheer    Category Formulas     Tags , ,

BESSELK function is for purely imaginary and this function will return the secondary linear independent modification. The BESSELK function can also be applied to a variety of real world processes such as electromagnetism and heat conduction.

If the BESSELK function returns to an error #NAME then you have to first install the Anelysis ToolPak. You can do this by selecting on the Tool bar the Add-Ins. After doing, click the box located next to Analysis ToolPak and hit OK. In this manner, you can install the BESSELK function and you can also follow the instructions provided.

The syntax of the BESSELK function is BESSELK(x, n). The value of X is the value to which the function is to evaluate. The N represents the order of the function which must not be lesser than zero.

To try an example, open a new Excel worksheet. On the A1 cell input the argument =BESSELK (2, 1). The argument will return into the value of 0.139866. This value is the first order modified Bessel function which is on the second kind for 1.5i. This function is evaluated for xi and not x.

To evaluate the BESSEL function with purely imaginary numbers you can use the formula K(x) = pi/2i^ (n+1)[J(ix)+iY(ix]. In this formula, the K(x) is the order of the solution at x and the i represents the square root of -1. The argument J(ix) and Y(ix) are unmodified Bessel functions of J and Y for ix for the order of n.

Remember that if the value of X is a non-numeric value the BESSELK function will result to a #VALUE. If the N is also in a non-numeric value it will still return or give a value of #VALUE which is an error value. Moreover, if the value of N is lesser than zero then the BESSLK will return to#NUM which means an error has occurred.

Further readings

Post comment