Skip to main content
P
ptc-54025431-Visitor
1-Visitor
November 29, 2013
Question

Area integration

  • November 29, 2013
  • 2 replies
  • 3122 views

I have sets of measurement data, time (s), temperature and detector response.

At certain temperatures (or time) I get a detector response that forms one or two peaks.

I need to calculate the area of these peaks, how to do this?

2 replies

A
AlanStevens19-Tanzanite
19-Tanzanite
November 29, 2013

Upload a worksheet with your data and what you've tried so far (at least plot the data). By 'area of these peaks' do you mean when plotted as a function of time or of temperature?

Alan

P
ptc-54025431-VisitorAuthor
1-Visitor
November 29, 2013

P
ptc-54025431-VisitorAuthor
1-Visitor
November 29, 2013

Somewhat wrong example because I usually get 2 peaks as can be seen by the small shoulder at 415 C.

What I need is the area under the curve between 340 and 570 degrees.

W
Werner_E25-Diamond I
25-Diamond I
November 29, 2013

Here is a routine which seems to do what you need.

29.11.png

An alternate approach woul have been to turn the table Temp/Signal into a function using some kind of interpolation (linear or spline). But to do so the vector Temp must consist of consecutive (sorted) values which is not the case in your sample data. So this problem would have to be addressed first by either sorting the vectors accordingly or cutting away the non sorted areas. The advantage with this approach would be that you could use the normal integral to get the area.

P.S.: Think you did a copy and paste to put the data values into this Prime table which seems not to be resizeable. I hide it in a collapsed region but wouldn't it be much more convenient (assuming you have more than one dataset to work on) to use an Excel component or simply READEXCEL() to get the data into the sheet?

EDIT: Appended second dataset via Excel component.

Terms & ConditionsAccessibility statement