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.
Updated
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 chart | Rank correlation | |
|---|---|---|
| Measures | The 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 from | The workbook, at the test points. | The trials of the run. |
| Correlations between assumptions | Not 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.