Is it possible to calculate integrals with Excel?

F

Francesco

Hi all, I wanted to calculate some functions containing integrals using
Excel, but it doesn't seem my Excel can calculate any kind of integral. Any
help?

F.
 
A

arno

Hi Francesco,
Hi all, I wanted to calculate some functions containing integrals
using Excel, but it doesn't seem my Excel can calculate any kind of
integral. Any help?
Click to expand...

integrals.... long time ago....

well, you cannot enter integrals directly, _you_ have to make the
algebra stuff until you have a formula that can be entered into excel.

arno
 
F

Francesco

Hi Arno, I hoped there was a more straight forward way of doing it, many
thanks anyway,

F.
 
J

Jerry W. Lewis

Excel does not natively offer calculus functionality. Some functions
can be integrated in closed form.
http://integrals.wolfram.com/
or
http://maxima.sourceforge.net/
may help identify some of these if your calculus is rusty.

Where closed form integrals do not exist (or where you do not know the
function), there are many methods for numeric integration.
http://www.stfx.ca/people/bliengme/ExcelTips/AreaUnderCurve.htm
implements a couple of simple methods in Excel. Chapter 4 of Numerical
Recipes in ... goes into more detail in C, C++, Fortran, or Pascal (out
of print). There may even have been one in Basic at one time. The C
and Fortran versions are available on-line
http://www.library.cornell.edu/nr/bookcpdf.html
http://www.library.cornell.edu/nr/cbookfpdf.html
Fortran is probably easier to translate into VBA than C.

Jerry
 
Top