Free Microsoft Excel 2013 Quick Reference

# Excel Curves- Area under the curve

I use chromotography(GPC) in my research. This gives bell shaped curve. To compare two cuvres, I need area under the curve. Can any one teach me the way of calculating area under the curve in excel worksheet?(The curve will be in the shape of "Normal distriubution" shape).

Saravanan

## Related Results

### How to calculate the area under the curve in the excel?

how to calculate the area under the curve in the excel?

### Finding the area under the curve in a graph in excel

Need help having excel calculate the total area under the curve of a graph in
excel.

### Area under the curve

How to find area under the curve in MS Excel Chart?

### Calculate area under the curve

Hi there, i am just wondering if anyone can help me of out to, i am getting some data via RS 232 port and plotting it straight to excel, which comes out to be in forms of waves you can say sine waves, now i need to calculate area under the curve, say like if i highlight some area it will automatically calculate the area, or if i select two points on the curve it will calculate the area. please help me out i am really stuck at this part.
regards
raza
320-237-5345

### 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

### How do I calculate the area under the curve using Excel?

Is there a function to calculate the area under the curve? I have tried to
use the AREAS(ref) function but failed at finding the area. Maybe I used it
wrong? Any help would be greatly appreciated =)

### 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!

### Area under the curve

Jon Peltier used a VBA technique to fill the area under the curve. It works
with me fine but if the value of the Y coordinate is below 0.001 then the the
procedure crashes.

Is there a way to correct the procedure??

See this chart for illustration
http://phpaw.com/myscrpit/milt-up/jp...1124275474.jpg

### Area under the curve of a trendline

Does anybody know how to find the area under the curve of a trendline (6th
degree polynomial in my case).

Thanks in advance for any help.

### Highlight area under the curve between 2 points

Hi there,
i am facing some problem in highlighting the area under the curve (not calculating ), i can calculate the area under the curve by the help of mike using this formula =SUMPRODUCT(--(D2

### Calculate the area under the curve

How can i calculate the area under the curve?

### Area under the curve for each peak in a graph of mulitple peaks?

In a graph of multiple peaks how do you find the area under the curve for
each peak?

### Area under the curve in a graph

Hi
Can anyone tell me hot to calculate area under the curve in a graph (xy
graph)? Thanks

### Area under a curve

I have several charts with data curves on them and can't have an eqn for the curve.

Is there a way to calculate the area under the curve using excel?

### How do i calculate the area under a curve?

I have a curve (that doesn not fit a simple equation) and want to calculate
the area under the curve. How is this done?

### Area Under the Curve

Hi there,

Can someone please let me know if I can calculate the area under a curve

It is a Line Chart and I want to calculate the area betwee the curve and the axes

Thanks a ton,
Baapi

### How to calculate the total area under a curve in excel?

I wonder whether integration tools are available in Excel? for example, to
use integration to calculate the total area under a curve. anyone has used
the function or knows about it? thank you expert.

### How do I calculate the area under a curve in an Excel graph?

I am trying to calculate the area under a curve in an excel graph, can anyone
help?
Thanks very much

### Excel: Area under a curve calculation

i need to calculate the area under a curve in MS excel, but there does not
appear to be function that does this. Have i missed it? I have used SPSS too,
but it also doesn't appear to calculate it. i have check both programs' help
databases, both online and offline.

It's a very useful tool, and should be included in the program.

HELP!

### Determine area under a curve in Excel

I have created two hydrographs in excel and I want to find out how to
determine the area under each curve

### UDF - AreaFit, Area Under Curve and Fit Equations

I wrote a User Defined Function that can calculate the Area Under the Curve using Simpsons Rule, the Trapezoid Rule, Left Rule, or Right Rule. I plan on using these Numerical Integration methods with my AP Physics students in a lab next year.

It can also calculate a fit equation for Linear, exponential, Ln, and Power functions.

Here is an example of the results. As you can see, when the fit is way off, the results do not make sense. I was unsure how to proceed with calculating r^2 values for nonlinear data. Hopefully someone, somewhere will find this uesful.

******** ******************** ************************************************************************>Microsoft Excel - Area Under Curve and Fit Function 6-16-05.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutC3D3E3F3G3H3C4D4E4F4G4H4C5D5E5F5G5H5C6D6E6F6G6H6C7D7E7F7G7H7C8D8E8F8G8H8C9D9E9F9G9H9C10D10E10F10G10H10C11D11E11F11G11H11C13D13E13F13G13H13C14D14E14F14G14H14C16D16E16F16G16H16C17D17E17F17G17H17C19D19E19F19G19H19C20D20E20F20G20H20=
ABCDEFGH1 Actual ShapeLinearPolynomialPowerExpLnSine2 True Equation7X + 45X^2 + 3X + 503 X^4.254.12 e^1.34XLN(4.56X)+2.35Sin(x)3Area Under
CurveAnalytical390.002316.67102102.172029263.6548.38-0.804Simpson390.002166.67101616.542031416.4148.389.205Trapezoid390.002168.75102088.182104609.8948.369.006Left372.502043.7588751.081424807.6047.799.687Right407.502293.75115425.272784412.1848.948.328Linear Fit:
AX + BA4.00-29.17-10599.34-382252.514.121.329B7.0050.004318.44129486.960.22-0.1110R^21.000.930.720.380.910.0111R^21.000.970.850.610.960.1012Exp Fit:
A e^BX 13A13.6547.84188.654.124.2312.6914B0.180.250.571.340.040.1615Ln Fit:
A + Ln(B) 16Ln Fit A39.00220.8310992.88265182.315.350.7917Ln Fit B26.93179.3814255.62394281.551.00-0.9418Power Fit
A X^B 19Power Fit A31.12165.69988.903347.115.311.8620Power Fit B0.991.014.505.160.20-0.16Sheet2
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

### Calculate the area under the XY SCATTER CURVE

Hi,

Can Anybody Pls Help Me In Calculating The Area Under The Xy Scatter
Curve.

Thanks.

--
vijay4u
------------------------------------------------------------------------
vijay4u's Profile: http://www.excelforum.com/member.php...o&userid=37243

### Separate area under a curve into two sections.

I have data that generates points where each X value is less than or equal to
the one before.

I can find the area under this curve determined by these points.

I want to know how to find the y-intercept for a line that is basically
horizontal, but becomes congruent with the line formed by the points above
after they intercect that is determined by a number representing the area
under it.

Here's my attempt to illustrate:

|
|
|.
| .
| .
| ...
| . I know these points
| .
| .
| .
| ......
| .
L|------------------...
| ...
|
| I know this area
| and the total area |
|
|________________________

I need the y-intercept of the line (L)
determined by the a particular area.

I hope this can be done without great dificulty in using Excel

Although I majored in math, and was quite good at it at one time, haven't
had occasion to do a calculus problem for the better part of 40 years.

Any help appreciated.

### Calculate the area under the XY SCATTER CURVE

Hi,

Can Anybody Pls Help Me In Calculating The Area Under The Xy Scatter Curve.

Thanks.