VoseSimProbability

MR-dice-icon.png Download a pdf copy of this help file  here

See also:  VoseSimCofV, VoseSimCorrelation, VoseSimCVARp, VoseSimCVARx, VoseSimKurtosis, VoseSimMax, VoseSimMean, VoseSimMin, VoseSimMoments, VoseSimMSE, VoseSimPercentile, VoseSimMeanDeviation, VoseSimSemiStdev, VoseSimSemiVariance,  VoseSimSkewness, VoseSimStdev, VoseSimTable, VoseSimVariance, VoseSimCorelationMatrix, VoseSimValue

VoseSimProbability(Cell Reference, Value, Simulation number)image1115.gif

 

 

1Excel_icon.gif Example model

This function returns the fraction of generated values in CellReference that fell below Value. In other words, the function returns the estimated probability that the variable being simulated in CellReference will fall below Value.

• Cell Reference - the cell for which the generated values are to be analyzed.

• Value – any real value for which we wish to know the estimated cumulative probability

• Simulation number – an index (1,2,3,…) referring to the simulation number. An optional parameter that is only required when one runs multiple simulations.