# To find the area inside the curve.

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 any one help me in this..

Thnx in advance
Rsh

#### Attachments

• data points.xls
55.5 KB · Views: 231
• ST-39-ENERGY.pdf
97.2 KB · Views: 169

## Answers and Replies

HallsofIvy
Science Advisor
Homework Helper
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
Homework Helper
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 any one 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.