VoseSimSemiVariance

Download a pdf copy of this help file  here

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

VoseSimSemiVariance(Cell Reference,TargetValue,Below, Simulation number)

Example model

This function returns the semi-variance of the cell during simulation.

• Cell Reference -  Should be a valid reference to a spreadsheet cell.

• Target Value - The threshold delineating the scenarios that represent a risk.

• Below - Specifies whether the scenario of interest is below the threshold (TRUE) or above it (FALSE).

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