View source for Tornado charts

[[Category:Analytica User Guide]]
<breadcrumbs>Analytica User Guide > Statistics, Sensitivity, and Uncertainty Analysis > {{PAGENAME}}</breadcrumbs>
{{ReleaseBar}}

A tornado diagram is a common tool used to depict the sensitivity of a result to changes in
selected variables. It shows the effect on the output of varying each input variable at a time, keeping all the other input variables at their initial (nominal) values. Typically, you choose a “low” and a “high” value for each input. The result is then displayed as a special type of bar graph, with bars for each input variable displaying the variation from the nominal value. It is standard practice to plot the bars horizontally, sorted so that the widest bar is placed at the top. When drawn in this fashion, the diagram takes on the appearance of a tornado, hence its name. The figure below shows a typical tornado diagram.

:[[File:Chapter16_5.png]]

'''Create a tornado analysis:''' To perform a tornado analysis, you must:
# Select the result or output variable to perform the analysis on.
# Select the input variables that might affect the output.
# Decide what the low and high values are to be for each input variable.

'''''Note:''' The input variables do not need to be chance variables. In fact, tornado analysis is often applied to models with no chance variables.''

There are several options for selecting low and high values, including:
* Selecting the same absolute low and high levels for every input. This usually only makes sense if inputs are very homogeneous with identical nominal values.
* Selecting absolute low and high values separately for each input variable.
* Varying all inputs by the same relative amount, e.g., low = 90% of nominal, high = 110% of nominal.
* Varying all inputs between two given fractiles (aka percentiles, quartiles). This only makes sense if your inputs are uncertain variables. '''Example:''' Low = 10% fractile, High = 90% fractile, nominal = 50% fractile.

==Implementing a tornado analysis==

''For this example, assume we vary all inputs by the same amount.''

# Create an index variable containing a list of input variable identifiers. Suppose this is called <code>Vars</code>.
# Create a variable, <code>Level</code>, and define it as a self-indexed table. (To do this, select '''Table''' from the [[expr]] menu, and select self as an index.) From the edit table, set the self-index labels to read low and high. Set the value corresponding to low to 90%, and set the value corresponding to high to 110%.
#:
#: [[File:Chapter16_6.png]]
#:
#Create a node, <code>Tornado_Analysis</code>. Assume that the output variable is <code>Net_value</code>. Define <code>Tornado_Analysis</code> as:
#:     <code>WhatIfAll(X, Vars, Level*Vars)</code>{{Release||4.6|
#Create a node, <code>Input_Vars</code>, defined as:
#:   <code>sortIndex(-abs(Tornado_Analysis[Level = 'high'] - Tornado_Analysis[Level =  'low']))</code>
# Create a node, <code>Net_value_range</code>, to hold the final graph, defined as:
#:     <code>Tornado_Analysis[Vars = Input_Vars]</code>

Steps 4 and 5 are not necessary if you do not require your bars to be displayed from largest to smallest. If you do include steps 4 and 5, <code>Net_value_range</code> contains the results of the tornado analysis, otherwise the result is <code>Tornado_Analysis</code>.}}

It is possible in Analytica to use array abstraction to produce a set of tornado diagrams, with each tornado itself indexed by an additional dimension. Additional dimensions are already included if your output variable is itself an array result, in which case you have a tornado diagram for each element in the output value’s array value. {{Release||4.6|This flexibility is unique to Analytica; however, you should note that having multiple tornados in a single result complicates the problem of sorting the bars, since the sort order is, in general, different for the different bars. If you have extra indexes in your tornado analysis, you need to either skip steps 4 and 5 above, and display non-sorted Tornados, or select a single sort order based on whatever criteria fits your needs, realizing that not all tornados display in sorted order.}}

The [[WhatIfAll]] function typically provides the easiest method for implementing a tornado analysis in Analytica. Note that the third parameter to [[WhatIfAll]] controls the method by which inputs are varied for the analysis. For example:

* For the case where you select the same absolute low and high levels for every input, <code>Level</code> would be set to the absolute low and high values, and the third parameter to [[WhatIfAll]] would be simply <code>Level</code>.
* For the case where you select absolute low and high values separately for each input variable, you would index <code>Level</code> by <code>Vars</code>, fill in <code>Level</code>’s table appropriately, then set the third parameter to be just <code>Level</code>.
* And for the case where you vary all inputs between two given fractiles, you would set <code>Level</code> to the desired fractiles, and use the expression <code>[[GetFract]](Net_value, Level)</code> as the third parameter.

=== Graphing a tornado ===
It’s customary to graph a tornado with the names of the input variables are listed down the vertical axis, and the bars displaying the effect on the output horizontally:

# Select '''Show Result''' for the <code>Tornado_Analysis</code> {{Release||4.6|or <code>Sorted_Tornado</code>}} variable. Press the '''Graph''' button if necessary.
# Pivot the index order (if necessary) so that <code>Vars</code> is on the X-axis and <code>L</code> is the <code>Key</code>.
# Select '''Graph Setup''' and the '''Chart Type''' tab.
# Set the ''Line Style'' to the filled bar setting and check the ''Variable origin'' checkbox. This will also set ''Bar Overlap'' = 100% and ''Swap horizontal and vertical'' for you. {{Release|5.0||
# Set the '''Sort by data spread''' checkbox. }}
# Click '''Apply'''.
# Next, we want to compare to the baseline value of <code>Net_Value</code>. Click the '''XY''' button to open the '''XY Comparison Sources''' dialog, check ''Use another variable'', press '''Add...''', and in the '''Object Finder''' select the variable <code>Net_Value</code>. Press '''OK''' twice.
# In the Bar Origin pulldown, select <code>Net_value</code>.

==See Also==
* [[GetFract]]
* [[Tornado Plots]]
* [[XY Comparison]]
* [[Graph setup dialog]]
* [[WhatIfAll]], [[WhatIf]]

<footer>Sensitivity analysis functions / {{PAGENAME}} / X-Y plots</footer>