Applies to: @RISK 6.1.1 and Up

Tornado Graphs Showing Change in Output Statistics

 

Can @RISK produce a tornado graph showing change in output mean, percentile, or mode?
Yes, by using the RiskSensitivityStatChange function.

 

Can those statistics be written to my worksheet?
Yes. The RiskSensitivityStatChange function allows you to calculate and write changes in output statistics directly to worksheet cells. These values can then be used for analysis, reporting, or custom charts.

 

How does this work in practice?
Instead of ranking inputs by correlation or regression coefficients, RiskSensitivityStatChange measures how much a chosen output statistic changes when each input is varied over its defined range. You can specify whether the statistic of interest is the mean, a percentile, or the mode.

 

Why might results differ by statistic?
Inputs often rank differently depending on whether you analyze change in mean, change in percentile, or change in mode. Each statistic reflects a different aspect of the output distribution, so the most influential inputs can vary based on which measure you choose.

 

Where can I find examples?
The @RISK Help documentation includes details on RiskSensitivityStatChange. In addition, example workbooks demonstrate how to retrieve change in output mean, mode, and percentile and display them in tornado graphs.

 

Related Article:

Interpreting Change in Output Statistic in Tornado Graphs

 

Attachments:
KB1077_ChangeInOutputStat.xlsx