![]() |
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? |
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? |
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? |
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