Area under the curve calculation

H

Hetz

Hi all,

I've got a set of data consisting of some curves, displaying time i
minutes on the X-axis and the blood concentraction of substance A o
the Y-axis. The X-axis consists of 13 measurements (0, 15, 30,...to 18
minutes). So these curves show the concentration of substance A over
180 minutes period.
Can anyone please explain how to calculate the area under the curv
(AUC) of these curves? Is it possible to do that in Excel?
Thx alot!
:
 
D

darkxer0x

to calculate the area under the curve you have to do the integral in th
interval 0, 180. You have to get the relationship between x-axis and
a-xis. For example, x = 1, y = 1; x= 2, y = 2 --> y = f(x) = x. Th
area in the interval 0, 180 is x*x/2 ( x = 180) = 180*180 /2 = 90 * 18
(is the area of a triangle b*h/2
 

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

Calculation of Area Under a Continuos curve......Scatter Curve. 0
Calculation of Area Under a Continuos curve...... 5
Standard Deviation Curve 2
calculating area under a sin curve 1
How to determine the area under a curve (integration) in Excel? 1
S curve Calculation in Excel. 1
Graphic by curve - extract area 2
Area Under the Curve 1

Top