area under a curve in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
Ionman,

As an example, assume you set up an XY chart with these data points. The
title "X" is in cell A1 and the entire range covers A1:C11. The points in
column X are hardcoded:

X Y Areas
0 0.000 12.856
40 0.643 32.552
80 0.985 37.017
120 0.866 24.161
160 0.342 6.840
200 -0.342 24.161
240 -0.866 37.017
280 -0.985 32.552
320 -0.643 12.856
360 0.000

The formula in cell B2 is:

=SIN(RADIANS(A2))

Copy this formula down column C until you hit cell B11.

To calculate the area, add this formula to cell C2:

=IF(B2*B3>=0,ABS(((B2+B3)/2)*(A3-A2)),ABS(((B2^2+B3^2)/(B2-B3)/2)*(A3-A2)))

Copy the formula down the range of cell C2 to cell C10. Total the results
in range C2:C10 to calculate the total area.

This formula is not truly accurate as shown above. Generally, the more data
points that you add the better the more accurate the results.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

area under the curve in a graph 1
calculate area under a curve 0
Seemingly random plot area drift? 2
how can i determine the area under a graph ( distance vrs height) 1
how to calculate the area under a curve 1
Calculation of Area Under a Continuos curve......Scatter Curve. 0
How do I partially fill a plot area with color? 4
Mixing scatter plot with a category plot 2

Back
Top