MonteGrid | Articles | Sensitivity analysis in MonteGrid

Sensitivity analysis in MonteGrid

MonteGrid shows two sensitivity charts for each forecast: a tornado chart by Crystal Ball's method, and the rank correlation of each assumption with the forecast.

Tornado chart

MonteGrid tests each assumption at its 10th, 30th, 50th, 70th and 90th percentiles, with all other assumptions at their cell values. A bar spans the resulting range of the forecast, and its labels are the tested values of the assumption. Up to ten bars are shown, widest first. An asterisk marks a bar that is not monotonic: the extreme of the forecast lies inside the tested range.

Crystal Ball's tornado tool tests "Percentiles of the variables" by default, with a test range of 10% to 90% and five test points. MonteGrid uses the same method and the same points, so a model moved from Crystal Ball gives a tornado chart on the same basis.

Rank correlation

MonteGrid calculates the Spearman rank correlation between the sampled values of each assumption and the forecast, over all trials. At most eight assumptions are shown, and none below 0.05 in magnitude. Click an assumption to plot its trials against the forecast.

@RISK's correlation method for tornado graphs also ranks inputs by Spearman rank correlation with the output (Sensitivity Analysis).

Two charts, two questions

Tornado chartRank correlation
MeasuresThe change in the forecast when one assumption moves across its range and the others stay at their cell values.The rank correlation of each assumption's samples with the forecast.
Calculated fromThe workbook, at the test points.The trials of the run.
Correlations between assumptionsNot included: each assumption moves alone.Included.

In the capital budgeting model of the tutorials, Volume Growth is fifth in the tornado chart and second in the rank correlations, because the run correlates it with Year 1 Volume. The procedure is in Review the results.

In the report

Create Report writes a workbook in the layout of a Crystal Ball report. It contains the tornado and sensitivity tables and charts, with the statistics and percentiles of each forecast and the parameters of each assumption.

Sources

  1. Oracle: Tornado input options (Crystal Ball User's Guide)
  2. Lumivero: Sensitivity Analysis (@RISK help)

All articles