Applies to: @RISK 5.x and Up

 

How can I place the mean or a given percentile of an input distribution in my workbook?

Can I choose between simulation results and the perfect theoretical statistics?

Answer:
Yes. @RISK provides two parallel sets of statistic functions that you can use directly in worksheet cells.

The theoretical statistics functions have Theo in their names, such as RiskTheoMean() and RiskTheoPtoX().

• You can insert them via Insert Function » Statistic Functions » Theoretical.
• These return the exact statistics implied by the distribution parameters.
• They work before, during, and after a simulation, and only change if you modify the distribution itself.

The simulation result statistics (without Theo in the name) are available under Insert Function » Statistic Functions » Simulation Result.

• These are computed from the simulated values, so they change from run to run within normal statistical variation.
• Before the first simulation they return no meaningful values, and during a simulation they return #N/A unless you configure them to be calculated at every iteration.

In short, use Theo functions for stable, exact distribution properties, and use the non-Theo functions when you want statistics based on the actual simulation results.