Area beneath (or above) curve on graph

[Billybob4900]

I was hoping anyone could tell me how, or if excel even can, calculate the area beneath a curve? I can't find an appropraite funtion to return this information in the statistics menu, but something tells me that there should be one. If anyone knows that would be great.

I am actually graphing depth of streams, so my curves are concave-down. If the function to work out area beneath a curve can be altered to work out the area *above* one, then the formula would be very useful...and I would be eternally grateful.

Thanks!

[Mallycat]

This is quite complex and I don't know if you can do it. sounds like you need a calculus addin

Matt

[Norman Jones]

Hi Billybob,

See:

http://www.stfx.ca/people/bliengme/E...UnderCurve.htm


---
Regards,
Norman


"Billybob4900" <Billybob4900.29lemn_1150625401.8552@excelforum-nospam.com>
wrote in message
news:Billybob4900.29lemn_1150625401.8552@excelforum-nospam.com...
>
> I was hoping anyone could tell me how, or if excel even can, calculate
> the area beneath a curve? I can't find an appropraite funtion to return
> this information in the statistics menu, but something tells me that
> there should be one. If anyone knows that would be great.
>
> I am actually graphing depth of streams, so my curves are concave-down.
> If the function to work out area beneath a curve can be altered to work
> out the area *above* one, then the formula would be very useful...and I
> would be eternally grateful.
>
> Thanks!
>
>
> --
> Billybob4900
> ------------------------------------------------------------------------
> Billybob4900's Profile:
> http://www.excelforum.com/member.php...o&userid=35537
> View this thread: http://www.excelforum.com/showthread...hreadid=553006
>