Engineering functions bessel, besseli, besselj, besselk, bessely

Excel Function BESSELI

The BESSELI() function is used to determine the Bessel function of imaginary coordinates.

The Bessel function is most often used in wave propagation problems.

This function is also called as cylinder functions.

These functions are most often found in the Laplace equations.

Number n Value BESSELI Formula
2 2 0.688948449197763 =BESSELI(L5,M5)
5 3 10.3311501959995 =BESSELI(L6,M6)
4 5 0.504724372851496 =BESSELI(L7,M7)
6 2 46.7870948981834 =BESSELI(L8,M8)
1 1 0.565159097581943 =BESSELI(L9,M9)

 

 

Excel Function BESSELJ

The BESSELJ() function returns the Bessel function in terms of Jn for the given order and value.

This function takes two arguments, one is value and the other represents order.

This function returns Bessel function values of purely imaginary part.

Number n Value BESSELJ Formula
2 2 0.352834207514176 =BESSELJ(L19,M19)
5 3 0.364831233515002 =BESSELJ(L20,M20)
4 5 0.132086656055948 =BESSELJ(L21,M21)
6 2 -0.242873212545006 =BESSELJ(L22,M22)
1 1 0.44005058567713 =BESSELJ(L23,M23)

 

 

Excel Function BESSELK

The BESSELK() functions calculates the Bessel function value with respect to Kn(x).

This function is also known as Hyperbolic function.

This function also takes into account, the imaginary part of the equation only.

Number n Value BESSELK Formula
2 2 0.25375976 =BESSELK(L32,M32)
5 3 8.29176837140317E-03 =BESSELK(L33,M33)
4 5 0.154342548813926 =BESSELK(L34,M34)
6 2 1.69196756562546E-03 =BESSELK(L35,M35)
1 1 0.601907231666906 =BESSELK(L36,M36)

 

 

Excel Function BESSELY

The BESSELY() function is used to determine the Bessel function with respect to Yn(x).

This function is also termed as Weber function.

This function takes two arguments, order and value.

Number n Value BESSELY Formula
2 2 -0.617408098385051 =BESSELY(L45,M45)
5 3 0.146267163302253 =BESSELY(L46,M46)
4 5 -0.795851418214675 =BESSELY(L47,M47)
6 2 0.229857908031025 =BESSELY(L48,M48)
1 1 -0.78121282095312 =BESSELY(L49,M49)

The Bessel functions are most often used in Engineering field especially in wave propagation problems.

This function is also used in determining solutions for differential equations.

Strong knowledge of Laplace and Wave equation is required to understand these functions.

 

You can find similar Excel Questions and Answer hereunder

1) engineering functions arithmetic operations of complex numbers complex imabs imaginary imargument imconjugate imreal

2) engineering functions trignometric functions of complex numbers imsin imcos imtan imcsc imsec imcot

3) engineering functions number conversions binary and decimal bin2dec bin2oct bin2hex dec2bin dec2oct dec2hex

4) engineering functions trignometric functions of complex numbers imsinh imcosh imcsch imsech

5) engineering functions comparison and error functions convert delta erf erfc gestep

6) engineering functions number conversions octal and hexadecimal oct2bin oct2dec oct2hex hex2bin hex2dec hex2oct

7) engineering functions arithmetic operations of complex numbers imdiv improduct imsum imsub imsqrt

8) engineering functions log functions with complex numbers imln imlog10 imlog2 impower imexp

9) How can I calculate values applying complex Engineering formulas using Excel?

10) basic math functions hyperbolic functions sinh cosh tanh csch sech coth

 

Here the previous and next chapter