SimulationVariance
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationVariance(Reference Cell, Biased)
Function arguments:
| Reference Cell | Cell to use as source |
| Biased | (Optional) bias |
This function returns the variance of the reference cell during the simulation.
Set the bias parameter to FALSE (or leave blank) to find the unbiased
variance (using n-1). Set bias to TRUE to find the biased or
population variance (using n).