VoseSimPercentile | Vose Software

VoseSimPercentile

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)

 

 

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.

 

Navigation