RiskSemiStdDev

Description

RiskSemiStdDev (cellref or output/input name,lower_data,Sim#) returns the semi standard deviation of the simulated distribution for cellref, or the standard deviation of the values in the distribution below the mean.  You can use the RiskTruncate property function to optionally restrict the range of the simulated distribution for calculating the statistic.

Examples

RiskSemiStdDev (A10) returns the semi standard deviation of the simulated distribution for cell A10.

Guidelines

lower_data of TRUE specifies that the data <= the mean is used (the default), FALSE that the data >= the mean is used.