To find the area inside the curve.

  • Thread starter rsh
  • Start date
  • #1
rsh
1
0
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

  • #2
HallsofIvy
Science Advisor
Homework Helper
41,833
964
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?
 
  • #3
I like Serena
Homework Helper
6,577
176
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.
 

Related Threads on To find the area inside the curve.

  • Last Post
Replies
21
Views
3K
  • Last Post
Replies
4
Views
834
  • Last Post
Replies
5
Views
1K
  • Last Post
Replies
2
Views
2K
Replies
1
Views
6K
  • Last Post
Replies
4
Views
12K
Replies
1
Views
2K
Replies
9
Views
7K
  • Last Post
Replies
2
Views
674
Top