RiskFunctions

XLRisk distribution functions

To describe the uncertainty in your model you can use the distribution functions provided by XLRisk (also referred to as risk functions). The list of these functions is currently short, but it will be expanded in the near future.

Depeanding on the "Show samples" setting these functions, when entered into the spreadsheet, they will return (shhow), either a sample of the distribution or its mean value. You can enter these functions using the Excel "Insert function" dialog box.

List of distribution functions

1. RiskNormal(mean, stdev): Generates samples from a normal distribution, with the given mean and standard deviation.
2. RiskUniform(min, max): Generates samples from a unifor distribution between min and max.
3. RiskTriang(min, most likely, max): Generates samples from a triangular distribution, with the given minimum most-likely and maximum value.
4. RiskBeta(alpha, beta, A, B): Generates samples from a beta distribution, with the given shape parameters alpha and beta. Optionally provide A and B as the minimum and maximum. The parameters are the same as in the built-in BETA.INV function.
5. RiskPert(min, most likely, max): Generates samples from a PERT distribution, with the given minimum most-likely and maximum value. The PERT distribution is a special case of the Beta distribution and can be used as a smoother version of the Triangular distribution.