HomeTechniques and Tips@RISK Simulation: Numerical ResultsProbability of an Interval

6.11. Probability of an Interval

Applies to: @RISK 5.x–7.x

From a simulated output or input, I'd like to find the probability of the result occurring in an interval, between a lower and an upper limit.

An easy way is to click the output, click Browse Results, and adjust the sliders to the limits you're interested in. The probability then shows in the horizontal bar between the two sliders.

I really wanted this as a worksheet function.

No problem! The probability of the interval is the cumulative probability of the upper limit, minus the cumulative probability of the lower limit. Assuming your output is in cell DF1, and the limits are 100 and 200, the formula is:

=RiskXtoP(DF1,200)-RiskXtoP(DF1,100)

If the limits are in cells DL1 and DH1, then the formula is:

=RiskXtoP(DF1,DH1)-RiskXtoP(DF1,DL1)

Last edited: 2016-05-04

This page was: Helpful | Not Helpful