Applies to: @RISK 5.0 and Up

Creating a Burr Type XII Distribution in @RISK

 

To model a Burr Type XII distribution, use its inverse CDF.
The CDF is F(x) = 1 – (1 + xᶜ)^(-k), giving the inverse:

x = [(1–F)^(-1/k) – 1]^(1/c)

@RISK draws a uniform 0–1 value and feeds it into the inverse CDF, so the Excel formula is:

=((1–RiskUniform(0,1))^(-1/k) – 1)^(1/c)

Wrap it in RiskMakeInput so @RISK treats it as an input:

=RiskMakeInput(((1–RiskUniform(0,1))^(-1/k) – 1)^(1/c), RiskName("Burr"))

Replace c and k with values or cell references.

Attachments:
KB1260_BurrDistribution.xlsx