Crystal Ball can create spider plots and tornado charts changing one variable at a time, using the following steps:

Click "CBTools" >> Tornado Chart;

Select the forecast or formula cells to target;

Click "Next"

Select the assumptions, decision variables and precedents to analyze (performing a crude sensitivity analysis will guide you);

Click "Next"

Specify the cumulative probabilities you wish to test in the "Tornado Input" window;

Crystal Ball then:

Selects an input distribution;

Replaces the distribution with one of the percentiles you specified;

Calculates the value of the forecast, using "median" or "existing cell values" (you can specify this);

Selects the next cumulative percentile and calculates the forecast value again;

Repeats until all percentiles have been calculated, then put back the Crystal Ball distribution, and move on to the next selected input

Once all inputs have been treated this way, we can plot the following **Spider Plot:**

Often this type of plot has several horizontal lines for variables that have almost no influence on the output. It makes the graph a lot clearer to delete these.

Now we can very clearly see how the output mean is influenced by each input. The vertical range produced by the Sales price line shows the range of expected profits there would be if the Marketing costs was fixed somewhere between the minimum and maximum (a range of $5,000). The next largest range is for the Distribution costs ($3500), etc. The analysis helps us understand the degree of sensitivity in terms we understand rather than correlation coefficients that other sensitivity analysis techniques use.

The Tornado Chart Tool can also plot a **Tornado chart** (also using the "Tornado Chart Tool" in Crystal Ball). The numbers on the left and right of the bars represent the most extreme percentile results.

**Caveats:**

Because the Tornado Chart Tool changes one variable at a time (independently of the other), it cannot account for multiple impacts of a variable through correlation and other dependency relationships.

The results are depending on the base case used for the variables. Therefore, we recommend that you run the tool more than one time with different base cases

**Differences with @RISK:**

The steps taken in @RISK advanced sensitivity analysis are fairly similar to those described above, but instead of *calculating* the forecast, the forecast values are *simulated* and the analyst can chose what statistic (e.g. the mean) will be reported. Because in this analysis the results are simulated, correlations and other dependency relationships are taken into account, making it a more robust option.