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
   414   415   416   417   418   419   420   421   422   423   424