HomeTechniques and Tips@RISK DistributionsSetting the "Return Value" of a Distribution

3.3. Setting the "Return Value" of a Distribution

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

For cells in my model that are probabilistic (directly or indirectly), how do I change the value that is displayed in the cell when a simulation is not running?

By default, when a simulation is not running you will see static values: the displayed values of @RISK distributions won't change during an Excel recalculation. The default static value for continuous distributions is the mean value (expected value). For discrete distributions, the default static value is not the true expected value but rather the value within the distribution that is closest to the expected value: for example, RiskBinomial(9,0.7) will display 6 rather than 6.3.

Outputs, and other values computed from the inputs, generally don't display their own mean or expected value but rather the value computed from the displayed values of inputs. Please see Static Value of Output Differs from Simulated Mean.

There are several ways you can change the displayed values of input distributions, and the resulting displayed values of outputs.  None of these methods will affect a simulation in any way.

Which static values are displayed?

@RISK lets you choose to display the expected value, true expected value, mode, or a selected percentile for all distributions. ("True expected value" is the same as expected value for a continuous distribution. For a discrete distribution, true EV is the mathematical mean of the distribution. For example, the true EV of RiskBinomial(9,0.7) is 6.3.) You can make this choice in either of two places:

You can also put a RiskStatic( ) function in an individual distribution to override the above for that distribution only. Example:

=RiskNormal(100, 10, RiskStatic(25) )

Display random values instead of static values

You can suppress the static values and have @RISK generate new random values for each distribution when Excel does an automatic recalculation or when you press F9 to force a manual recalculation. To switch between random and static values for all open workbooks use either method:

You can also change @RISK's default from static values to random values in the Application Settings dialog, as mentioned above.

Last edited: 2015-06-19

This page was: Helpful | Not Helpful