What if Analysis

By using what-if analysis tools along with Microsoft Office Excel, you can use several different sets of values in one or more formulas to explore all the various results in form of Tornado Analysis, Spider Analysis and Sensitivity Analysis

Spider Analysis

This type of analysis makes it possible to make variations, by percentages, in the same amounts for all input variables.

The more inclined a parameter’s line is to the horizontal line, the more significant the change in the value of the target optimal solution or function is whenever the parameter’s value changes.

Tornado Analysis

A Tornado Chart ranks input parameters in terms of their impact on the output. It provides a convenient way to determine the relative sensitivity of the results to an entire set of input parameters.

The Tornado Chart tells us that the greater the corresponding bar in the tornado chart, the greater the sensitivity and importance of that parameter to generate output.



Sensitivity Analysis

It shows tables with constant variations of each input variable (variations which you define - with a base value, an increase value and a ceiling) and the effect of such changes in changes to output variables. Data Sensitivity is used to trace the effect on an output of changes in one (or two) inputs.