BESSELJ Excel Formula

Author Zaheer    Category Formulas     Tags , ,

Excel offers a lot of helpful function for solutions and formulas even for daily regular accounts. These functions are the shortened formulas which can be used to solve or to create solutions in Excel. These are very useful especially when you tend to use long formulas and arguments.

One of the helpful functions of Excel is BESSELJ function. This returns the solution to the first independent linear solution for the Bessel function. In addition, Bessel function can be applied realistically in heat conduction and electromagnetism.

Before trying the function make sure that you have installed the function. You can do this by installing and loading the Analysis Toolpak. Select on the Tools on the menu bar and click Add-Ins. On the Add-Ins available list next, select the Analysis ToolPak dialogue box and click on OK. Try to follow the instructions in the setup program if needed.

For starters, syntax is a series of arguments used to form your formula. The syntax of the BESSELJ function is BESSELJ(x, n).

The value of X in this argument is the value wherein the Bessel function is evaluated. The N in the function is the order of the Bessel function. If the value of X in the argument is non-numeric then the BESSELJ will have an error value of #VALUE. In addition, if the N in the argument is non-numeric then it will have the same error value. If N is lesser than zero, the return value will be #NUM.

Try an example by opening an Excel worksheet. Click on the cell A1 and input the argument =BESSELJ (1.9,2). The return value is 0.329926. The solution is to the second order Bessel function of its first kind for 1.9. The result of the solution can be checked with the given values for the equation x=1.9 and n=2. Click on the origin cell and the formula will be seen on the Formula Bar.

As an evaluative measure, you can use the equation J(x)= the sum of [((-1)^k/(k!T(n+k+1))(x/2)^(n+2k)]. T is gamma function and the expression has a total of every integer k which is equal to or more than zero. T (n+k+1) is the gamma function which is equal to the integral equation e^ (ik)x^(n+k)dx which will be evaluated with the zero interval or to infinity.

Post comment