ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   can I find the area under a plotted curve? (https://www.excelbanter.com/excel-worksheet-functions/173673-can-i-find-area-under-plotted-curve.html)

Middlesex

can I find the area under a plotted curve?
 
I plotted the curve y = 1200-4x. Can I find the area under the curve from 0
to 5 using an excel function?

MartinW

can I find the area under a plotted curve?
 
Hi,

Bernard Liengme has a way, look here.
http://people.stfx.ca/bliengme/Excel...UnderCurve.htm

HTH
Martin


"Middlesex" wrote in message
...
I plotted the curve y = 1200-4x. Can I find the area under the curve from 0
to 5 using an excel function?




Middlesex

can I find the area under a plotted curve?
 
Thanks Martin



"MartinW" wrote:

Hi,

Bernard Liengme has a way, look here.
http://people.stfx.ca/bliengme/Excel...UnderCurve.htm

HTH
Martin


"Middlesex" wrote in message
...
I plotted the curve y = 1200-4x. Can I find the area under the curve from 0
to 5 using an excel function?





Jerry W. Lewis

can I find the area under a plotted curve?
 
Excel doesn't know calculus. You could program numerical integration (such
as described on Bernard Liengme's web page), but it is unclear why you would
want to when you have an analytically integrable function. The area under
the curve y=1200-4*x from a to b is (b-a)*(1200-2*(a+b)). If you have
limited calculus skills, you might find Maxima to be helpful
http://maxima.sourceforge.net/

Jerry

"Middlesex" wrote:

I plotted the curve y = 1200-4x. Can I find the area under the curve from 0
to 5 using an excel function?



All times are GMT +1. The time now is 07:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com