Skip to content

RiskFunctions

pyscripter edited this page Mar 16, 2019 · 9 revisions

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.
Clone this wiki locally