VoseSimProbability

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)

 

 

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.

 

ModelRisk

Monte Carlo simulation in Excel. Learn more

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Navigation

FREE MONTE CARLO SIMULATION SOFTWARE

For Microsoft Excel

Download your free copy of ModelRisk Basic today. Professional quality risk modeling software and no catches

Download ModelRisk Basic now

FREE PROJECT RISK SOFTWARE

For Primavera & Microsoft Project

Download your free copy of Tamara Basic today. Professional quality project risk software and no catches.

Download Tamara Basic now
-->