Hi,

Can Anybody Pls Help Me In Calculating The Area Under The Xy Scatter
Curve.

Thanks.


--
vijay4u
------------------------------------------------------------------------
vijay4u's Profile: http://www.excelforum.com/member.php...o&userid=37243
View this thread: http://www.excelforum.com/showthread...hreadid=569571

Hello, vijay4u!
You wrote on Tue, 8 Aug 2006 15:03:23 -0400:

v Can Anybody Pls Help Me In Calculating The Area Under The Xy
v ScatterCurve.

You are really asking about doing numerical integration and
there are lots of recipes for it. You could try a Google search
for

Excel "numerical integration".

A web site that comes up early in the listing is from Oregon
State and it's not bad. If you have a fair number of points,
Simpson's rule is quite easy to use.

Another possibility is to fit an equation to your data and
integrate the result algebraically .....polynomials are trivial
and exponentials are not that bad if you recall your high school
algebra.


James Silverton
Potomac, Maryland

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

See Bernard Liengme's
http://people.stfx.ca/bliengme/Excel...UnderCurve.htm
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Hi,

Can Anybody Pls Help Me In Calculating The Area Under The Xy Scatter
Curve.

Thanks.


--
vijay4u
------------------------------------------------------------------------
vijay4u's Profile: http://www.excelforum.com/member.php...o&userid=37243
View this thread: http://www.excelforum.com/showthread...hreadid=569571