BESSELK Excel Formula
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
Categories
Recent Posts
- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro