VoseSimCVARx

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

VoseSimCVARx(Cell Reference, xValue, Simulation number)

 

 

 

Example model

 This function returns the Conditional Value-at-Risk during simulation based on an x-value.

Cell Reference -  Should be a valid reference to a spreadsheet cell of the distribution of loss.

xValue  -  A threshold loss value above which CVAR is calculated.

Simulation number  -  Optional simulation number parameter. Must be an integer>=1. Equals 1 if omitted.

 

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
-->