VoseSimSemiStdev | Vose Software


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

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




Example model

This function returns the semi-standard deviation 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.