Continue to Site

Welcome to EDAboard.com

Welcome to our site! EDAboard.com is an international Electronics Discussion Forum focused on EDA software, circuits, schematics, books, theory, papers, asic, pld, 8051, DSP, Network, RF, Analog Design, PCB, Service Manuals... and a whole lot more! To participate you need to register. Registration is free. Click here to register now.

Register Log in

Excel and Airy function's

Status
Not open for further replies.
J

jimmy neutron

Newbie level 6
Joined
Dec 30, 2009
Messages
12
Helped
1
Reputation
2
Reaction score
0
Trophy points
1,281
Location
UK
Activity points
1,369
Does anyone know if it is possible to determine Airy functions in Excel? I thought of using the formula that give Ai(x), Bi(x) in terms of Bessel functions:

Ai(x) = 1/pi sqrt(x/3) K_1/3(2/3x^3/2)

Bi(x) = sqrt(x/3) ( I_1/3(2/3x^3/2) + I_(-1/3)(2/3x^3/2) )

However, Excel does not evaluate Bessel functions of negative fractional order.
 

Would LibreOffice do? I just checked and it is possible to evaluate BESSELI(X,-1/3) in LibreOffice Calc. You can then export the numerical results back into Excel if they needed to be used somewhere else on your spreadsheet. It doesn't allow for a live Excel document, though. Maybe you can move all to LibreOffice.
 

Status
Not open for further replies.

Similar threads

Part and Inventory Search

Welcome to EDABoard.com

Sponsor

Back
Top