Area under the curve calculation
 

Hi all,

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


--
Hetz
------------------------------------------------------------------------
Hetz's Profile: http://www.excelforum.com/member.php...o&userid=35758
View this thread: http://www.excelforum.com/showthread...hreadid=557568

Area under the curve calculation
 

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


--
darkxer0x
------------------------------------------------------------------------
darkxer0x's Profile: http://www.excelforum.com/member.php...o&userid=35967
View this thread: http://www.excelforum.com/showthread...hreadid=557568

Area under the curve calculation
 

See Bernard Liengme's
http://www.stfx.ca/people/bliengme/E...UnderCurve.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , Hetz.2a9puz_
says...

Hi all,

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


--
Hetz
------------------------------------------------------------------------
Hetz's Profile: http://www.excelforum.com/member.php...o&userid=35758
View this thread: http://www.excelforum.com/showthread...hreadid=557568