Calculating the area under a graph

[Guest]

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.

 

[Mangesh Yadav]

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


Mangesh

 

[Bernard Liengme]

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