Solving Integrals in Excel
Kelly Schwarzhoff
4.0? I want to be able to solve the integral by defining an equation and
then giving the range (for example, the equation x^2 and the range from 0
to 1 would give 1/3).
--
Kelly Schwarzhoff kel...@leland.stanford.edu
MIME Mail is welcome
Douglas B. Stein
Schwarzhoff, kel...@leland.stanford.edu writes:
>Does anyone know of a way to solve integrals using Excel for the
Macintosh
>4.0? I want to be able to solve the integral by defining an equation and
>then giving the range (for example, the equation x^2 and the range from 0
>to 1 would give 1/3).
I wrote (and Wolfram Research is about to release this month) an add-in
for Excel that uses our MathLink protocol to call Mathematica (which can
reside on the same machine as Excel or on another networked machine). You
can get numerical or exact symbolic integration. For example, here's how
to do the numerical integration:
=M.VALUE("NIntegrate[x^2, {x,0,1}]")
If you wanted the formula and limits pulled in from other cells (say A1,
A2, A3) an inelegant but effective method would be to concatenate the
cell contents:
=M.VALUE("NIntegrate["&A1&",{x,"&A2&","&A3&"}]")
The Macintosh version of "MathLink for Excel" costs $50 and will ship
this month. The Windows version will ship immediately after the
MathLink-capable Mathematica for Windows ships. It requires access to a
MathLink-capable version of Mathematica (you don't need a Mac version -
you can connect Excel to a networked Unix version of Mathematica). You
can contact us to get MathLink for Excel or Mathematica itself at:
Phone: 1-800-441-MATH
Email: in...@wri.com
Hope this helps,
Doug
------------------------------------------
Doug Stein
Member of Technical Staff
MathLink Development
Wolfram Research, Inc.
do...@wri.com