# forum.alglib.net

ALGLIB forum
 It is currently Tue May 28, 2024 11:15 am

 All times are UTC

### Forum rules

1. This forum can be used for discussion of both ALGLIB-related and general numerical analysis questions
2. This forum is English-only - postings in other languages will be removed.

 Page 1 of 1 [ 2 posts ]
 Print view Previous topic | Next topic
Author Message
 Post subject: numerical integration on excel vbaPosted: Fri Sep 02, 2011 8:26 am

Joined: Fri Sep 02, 2011 8:24 am
Posts: 1
hi, I'm new to excel vba programming, so i was looking for a complete aplied example using de vb6 package, what I need is to define and integrate a function F(x) on a finite interval [a,b].
for example:

Thank you very much!!!

Top

 Post subject: Re: numerical integration on excel vbaPosted: Sat Sep 03, 2011 6:56 am

Joined: Sun May 16, 2010 11:42 pm
Posts: 63
http://newtonexcelbach.wordpress.com/20 ... functions/
which has four spline interpolation functions:

CSplineInt1D =CSplineInt1D(X Coords, Y Coords, UBX, End Type 1, End 1, End Type 2, End 2)
AkimSplineInt1D =AkimSplineInt1D(X Coords, Y Coords, UBX)
HSplineInt1D =HSplineInt1D(X Coords, Y Coords, Derivatives, UBX)
CRSplineInt1D =CRSplineInt1D(X Coords, Y Coords, UBX, End Type, Tension)

For these you need to evaluate the function as a number of points, and the functions will fit a spline to those points and return the integral.

You might also like to have a look at:

which has routines that will evaluate the integral of a function entered as text, using the Tanh-Sinh method.

_________________
Doug Jenkins
http://newtonexcelbach.wordpress.com/

Top

 Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending
 Page 1 of 1 [ 2 posts ]

 All times are UTC

#### Who is online

Users browsing this forum: No registered users and 1 guest

 You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot post attachments in this forum

Search for: