Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I plotted the curve y = 1200-4x. Can I find the area under the curve from 0
to 5 using an excel function? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculation of Area Under a Plotted Graph | Excel Worksheet Functions | |||
Area under the curve | Charts and Charting in Excel | |||
Area Under the Curve | Charts and Charting in Excel | |||
Is there a way to have the plotted area of an excel graph to have. | Charts and Charting in Excel | |||
Area Under Curve | Excel Worksheet Functions |