• Knowledge Books
• Standalone Licenses
• Network Guide
• More on Networks
• End User Setup
• Techniques and Tips
• Troubleshooting
• Licencias individuales
• Guía para Administradores de Red
• Licencias de red
• Configuración de usuario final
• Técnicas y Consejos
• Soluciones
• Licenças Standalone
• Licenças de Rede
• Configuração do usuário final
• Técnicas e Dicas
• Soluções
• Obsolete Articles

• Main Support Page

Home → Techniques and Tips → @RISK Simulation: Numerical Results → Placing Contribution to Variance in Worksheet

6.27. Placing Contribution to Variance in Worksheet

Applies to: @RISK 7.5.0 and newer

I like the Contribution to Variance tornado, but how can I get those values into my worksheet?

When the new graph was created in @RISK 7.5.0, new values were added to the arguments of the RiskSensitivity function. For contribution to variance, follow these patterns:

• RiskSensitivity(output, , k, 4, 1) returns name of the k-th most significant input.
• RiskSensitivity(output, , k, 4, 6) returns percentage of total variance contributed by the k-th most significant input.
• RiskVariance(output) * RiskSensitivity(output, , k, 4, 6) returns actual variance contributed by the k-th most significant input, as opposed to percentage of variance contributed.

The first three arguments to the RiskSensitivity function are output cell reference or name, simulation number (omitted = simulation 1), and input rank (>=1, where 1 selects the input with greatest effect). The fourth argument is 4 for contribution to variance. The fifth argument is 1 for the name of the input with that rank, or 6 for the percentage of variance contributed.

Please open the attached workbook and run a simulation. The contributions to variance will appear in cells O9:Q15. The tornado graph is also shown for reference.

See also: All Articles about Tornado Charts

Last edited: 2018-08-11