AREA UNDER A IRREGULAR GRAPH

[arshad]

Hi,

Does anybody know how to calculate the area under a
irregular graph. Are complex equations required or is
there a facility in excel that can be used.

For example if we have the following values:-

2,3,4,5,6,1,11,2,4,5,6


When a staright line graph is created in excel then what
will the value under the graph be.

I hope somebody out there can assist me. Hope to hear from
you soon. You can e-mail me at (e-mail address removed)

Hope to hear from you soon, bye for now.

Regards,
Ash

 

[Jean Ruch]

Hello arshad,

here a link you should look at closer:
http://www.stfx.ca/people/bliengme/excelTips/areaundercurve.htm

With the one and (or) the other method you should achieve what you are
looking for

regards

Jean