SimulationStandardDeviation

RiskAMP Simulation Analysis Functions

Using this function in Excel:


=SimulationStandardDeviation(Reference Cell, Biased)

Function arguments:

Reference Cell	Cell to use as source
Biased	(Optional) bias

This function returns the standard deviation of the reference cell during the simulation.

Set the bias parameter to FALSE (or leave blank) to find the unbiased standard deviation (using n-1). Set bias to TRUE to find the biased or population standard deviation (using n).