area betwen 2 graphs
 

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

area betwen 2 graphs
 

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

http://people.stfx.ca/bliengme/Excel...UnderCurve.htm

Calculate both areas, then subtract.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Travis" wrote in message
...
Is there a way to get excel to calculate the area between 2 graphs?

area betwen 2 graphs
 

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

"Jon Peltier" wrote:

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

http://people.stfx.ca/bliengme/Excel...UnderCurve.htm

Calculate both areas, then subtract.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Travis" wrote in message
...
Is there a way to get excel to calculate the area between 2 graphs?

area betwen 2 graphs
 

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/Excel...UnderCurve.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

area betwen 2 graphs
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"James Silverton" wrote in message
...
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/Excel...UnderCurve.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

area betwen 2 graphs
 

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Travis" wrote in message
...
The problem is that the graphs are not curves, and are not friendly toward
formulas being applied. They are very irregular in shape.

"Jon Peltier" wrote:

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

http://people.stfx.ca/bliengme/Excel...UnderCurve.htm

Calculate both areas, then subtract.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Travis" wrote in message
...
Is there a way to get excel to calculate the area between 2 graphs?