How Do I Integrate?
 

I have a spreadsheet of about 100 data points of independent variables and
matching values for dependent variables. I want to integrate the resulting
curve to find the area underneath. How do I do this?

How Do I Integrate?
 

Myles,

To calculate the area under a curve, you can use

=SUMPRODUCT(A3:A100-A2:A99,(B3:B100+B2:B99)/2)

Where your x values are in A2:A100, and your Y values are in B2:B100. This is
an approximate method for finding the area under the curve, summing the area
of the trapezoids defined by pairs of points (and the points along the x
axis).

HTH,
Bernie
MS Excel MVP


"Myles" wrote in message
...
I have a spreadsheet of about 100 data points of independent variables and
matching values for dependent variables. I want to integrate the resulting
curve to find the area underneath. How do I do this?

How Do I Integrate?
 

see my Tip&Tricks site for more details

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Myles" wrote in message
...
I have a spreadsheet of about 100 data points of independent variables and
matching values for dependent variables. I want to integrate the
resulting
curve to find the area underneath. How do I do this?