Thread: Calculating the area under a graph

I am analysing a number of large graphs within Microsoft Excel 2000. It is
important that I calculate the area under these graphs. Can anyone tell me
how this can be done? Thank you in advance.

http://groups-beta.google.com/group/...rting/browse_t
hread/thread/877c08ec206cf7e/468b068ab8e4d657?q=area+under+graph&rnum=1&hl=e
n#468b068ab8e4d657


Mangesh



"William Woolnough" <William Woolnough@discussions.microsoft.com> wrote in
message news:D52EF713-619E-4308-8C67-F1EE697F0C3F@microsoft.com...
> I am analysing a number of large graphs within Microsoft Excel 2000. It is
> important that I calculate the area under these graphs. Can anyone tell me
> how this can be done? Thank you in advance.

There are two ways:
a) using the trapezoid or Simpson's rule - see
www.stfx.ca/people/bliengme/ExcelTips
and
b) use LINEST to find the line of best fit; do a manual integration of the
function and compute the definite integral
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"William Woolnough" <William Woolnough@discussions.microsoft.com> wrote in
message news:D52EF713-619E-4308-8C67-F1EE697F0C3F@microsoft.com...
>I am analysing a number of large graphs within Microsoft Excel 2000. It is
> important that I calculate the area under these graphs. Can anyone tell me
> how this can be done? Thank you in advance.