Bessel function/directivity function

[DaveT]

Does anyone know how you get excel to calculate bessel functions. In
particular the directivity function x=kasin(theta) for pressure 2J1(x)/x.

Cheers in advance

 

[Jerry W. Lewis]

Help for "Bessel" lists the Bessel functions that are available from the
Analysis ToolPak (ATP). Each Help article also gives instructions for
installing the ATP if it is not already installed. Note that Excel's
implementation only supports orders that are integers.

For a more general implementation, you might look at R, which is freely
downloadable from
http://www.r-project.org/

There is an interface that allows R functions to be called from Excel
http://cran.r-project.org/contrib/extra/dcom/RSrv135.html

Jerry