Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 860
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 837
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculation of Area Under a Plotted Graph un1c0rn Excel Worksheet Functions 1 June 4th 07 11:24 AM
Area under the curve Kailash Charts and Charting in Excel 1 January 8th 07 04:45 AM
Area Under the Curve Baapi Charts and Charting in Excel 1 December 16th 05 08:15 PM
Is there a way to have the plotted area of an excel graph to have. Maureen D. Charts and Charting in Excel 1 April 21st 05 02:07 AM
Area Under Curve Ray Naidu Excel Worksheet Functions 2 January 15th 05 11:11 PM


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"