How Do I Integrate?

[Guest]

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?

 

[Bernie Deitrick]

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

 

[Bernard Liengme]

see my Tip&Tricks site for more details