To find the area inside the curve.

[rsh]

Hi all,

I want to find the area inside the curve present in my pdf attachment. (2nd graph).

I got this graph using the data points present in the excel worksheet.

Position column will be always same, but the force column varies.

I need a program in excel to do this for all my other force values. Can anyone help me in this..

Thnx in advance
Rsh

 

[HallsofIvy]

You say "area inside the curve" but position is given only by a single number. In order to have an "area" you have to have a two dimensional situation with position given by two numbers. Also you have a column labeled "force". What does that have to do with area?

 

[I like Serena]

Hi all,

I want to find the area inside the curve present in my pdf attachment. (2nd graph).

I got this graph using the data points present in the excel worksheet.

Position column will be always same, but the force column varies.

I need a program in excel to do this for all my other force values. Can anyone help me in this..

Thnx in advance
Rsh

In it simplest form the area would simply be the sum of all forces (if the position increments are the same each time).
Otherwise you need to calculate the difference of each positional increment, multiply it by the corresponding force, and sum all results (integration by rectangular interpolation).
If you need more accurate results, you'd need to apply the trapezoidal rule.
Or an even more advanced method of numerical integration, which can be found with google.