area betwen 2 graphs

  • Thread starter Thread starter Travis
  • Start date Start date
The problem is that the graphs are not curves, and are not friendly toward
formulas being applied. They are very irregular in shape.
 
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
 
I was afraid to ask what made the data too irregular for this approach
(Bernard's must be Simpson's or something similar).

- Jon
 
Hi,

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

Cheers
Andy
 
Back
Top