Knowledge Base


Sensitivity Analysis

Single-factor sensitivity is a useful way to understand risk in a model. You can look at single-factor sensitivity using the R-squared (R2) value from a linear regression; this is also called the coefficient of determination.

The R2 value will tell you how much of the variance in the model is explained by variance in one or more of the inputs to the model. The add-in function SimulationRSquared returns the R2 statistic for an independent value and a dependent value.

The independent value is the input – generally one of the random variables in your model. The dependent value is the output – the result of the model. Another way to think about this is that the result depends on the input.

Use the SimulationRSquared function to create a table of R2 values for your model, and then add an Excel donut chart for a visual representation.

For more, see wikipedia.

Wed May 06 2015

Search the Knowledge Base

Structured Data LLC

Structured Data LLC is a software services and consulting firm founded in 2005, with offices in New York and San Francisco.

More Information?

If you'd like more information, please enter your email address below and we will get in touch.

Contact Us