VoseSimPercentile

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, VoseSimProbability, VoseSimMeanDeviation, VoseSimSemiStdev, VoseSimSemiVariance,  VoseSimSkewness, VoseSimStdev, VoseSimTable, VoseSimVariance, VoseSimCorelationMatrix, VoseSimValue

VoseSimPercentile (Cell Reference, Percentile, Simulation number)image1115.gif

 

 

1Excel_icon.gif Example model

This function returns the value that corresponds to the required ‘Percentile’ from all simulated values generated in the defined cell.

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

• Percentile – a value between 0 and 1

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

For example, VoseSimPercentile(A1,0.9) will return the 90% percentile of the values generated in cell A1.