VoseIntegrate

Download a pdf copy of this help file  here

See also: Vose Integrate

VoseIntegrate(expression,min,max,steps, NonVolatile)

Example model 1

Example model 2

The Integrate Calculation window

Numerically integrates a real, continuous, univariate function between user-specified min and max boundaries.

The numerical integration performed is based on the Gauss-Kronrod quadrature formula.

• Expression - the integrand, surrounded by double quotation marks (""). The variable to be integrated over presented by a #.

• min - the lower bound.

• max -the upper bound.

• Steps - optional accuracy parameter: the number of steps to divide each sub-interval by on each iteration of the algorithm.

• NonVolatile - optional boolean parameter (TRUE/FALSE) to set recalculation mode. Set to FALSE (default) to evaluate the integral on each spreadsheet recalculation. Set to true to only evaluate at the moment of inserting the VoseIntegrate function.

To see how the NonVolatile parameter works, refer to a spreadsheet containing a randomly generated value in the integrand expression. In NonVolatile mode the returned value will remain the same when the spreadsheet is recalculated.

In the integrand, cell references and Excel's mathematical functions (e.g. SIN()) can be used in the formula, including VoseFunctions added by ModelRisk, so a valid integrand would be for example:

=VoseIntegrate("VoseNormalProb(#,10,1,0)*4*VoseLognormalProb(#,4,5)",9,12)