Click or drag to resize

MONTE.CDF

Return the probabilities Cell is less than or equal to Values.

Description

This computes the Cumulative Distribution Function of the empirical distribution of variates from Cell over the course of a simulation at Values. If the output range is larger than the size of Values it will use the end to keep track of the number of times this function has been called during the simulation.

Syntax

MONTE.CDF(Cell, Values)

  • Cell is a reference to the cell whos cumulative distribution function is to be computed.

  • Values is an array of values at which the cumulative distribution is computed.