Page 419 - Excel for Scientists and Engineers: Numerical Methods
P. 419
396 EXCEL: NUMERICAL METHODS
C u rv Area
Returns the area under a curve defined by a table of x- and y-values.
Syntax
CurvArea(x-values, y-values)
x- values the range of x-values in the table (independent variable)
y-values the range of y-values in the table (dependent variable)
Remarks
The arguments x-values and y-values can be either a reference to a range of cells
or a named range.
Errors (difference between returned value and correct value, when the latter can be
calculated using a formula) will depend on the number of "panels" in the table.
Example
CurvArea($A$5:$A$30,$C$5:$C$30) where the ranges $A$5:$A$30 and $C$5:$C$30
refer to a table of x- and y-values, respectively, defining a curve.
See Also
Integrate, Integrates, I nteg rateT