area betwen 2 graphs

[Travis]

Is there a way to get excel to calculate the area between 2 graphs?

 

[Jon Peltier]

You could use this technique from Bernard Liengme's web site:

http://people.stfx.ca/bliengme/ExcelTips/AreaUnderCurve.htm

Calculate both areas, then subtract.

- Jon

 

[Travis]

The problem is that the graphs are not curves, and are not friendly toward
formulas being applied. They are very irregular in shape.

 

[James Silverton]

Travis wrote on Wed, 16 Jan 2008 13:06:01 -0800:

T> "Jon Peltier" wrote:

??>> You could use this technique from Bernard Liengme's web
site:
??>>
??>>
http://people.stfx.ca/bliengme/ExcelTips/AreaUnderCurve.htm
??>>
??>> Calculate both areas, then subtract.
??>>
??>> - Jon
??>> -------
\ ??>>> Is there a way to get excel to calculate the area
between
??>>> 2 graphs?

T> The problem is that the graphs are not curves, and are not
friendly toward
T> formulas being applied. They are very irregular in shape.

You could readily set up something as simple as Simpson's rule
for each graph.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

 

[Jon Peltier]

I was afraid to ask what made the data too irregular for this approach
(Bernard's must be Simpson's or something similar).

- Jon

 

[Andy Pope]

Hi,

Can you describe or post a link to how your graph looks if Bernard's
approach will not suit.

Cheers
Andy