SimulationConfidenceInterval
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationConfidenceInterval(Reference Cell, Confidence Level)
Function arguments:
| Reference Cell | Cell to use as source |
| Confidence Level | Confidence level |
This function returns the confidence interval of the mean for the given reference cell at the specified confidence level.
The confidence interval of the mean describes the range that contains the true mean of the data, with the given confidence level.
This function returns a dyanmic array of two values, one column by two rows.