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
 
Top