VoseSimCVARp | Vose Software

VoseSimCVARp

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

VoseSimCVARp(Cell Reference, pValue, Simulation number)

 

 



Example model

This function returns the Conditional Value-at-Risk during simulation based on a p-value.

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

  • pValue  -  The right tail probability of exceedance for 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

Spreadsheet risk analysis modeling

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Project risk analysis

Navigation

Enterprise Risk Management software (ERM)

Learn more about our enterprise risk analysis management software tool, Pelican

Enterprise risk management software introduction