Skip to content

CorrelatedInputsExample

pyscripter edited this page Apr 7, 2020 · 5 revisions

Example with correlated inputs

The Correl Example.xlsx demonstrates how you correlate risk inputs using RiskCorrmat function. As you can see in the screenshot below, the model contains three sets of calculations. In all three cases the result is the sum of the same RiskNormal and RiskUniform distributions.

The Correl Example model

In the first case the two distributions are positively correlated with correlation 0.9. In the second case the two distributions are negatively correlated with correlation -0.9. And in the third case the two distributions are not correlated.

If you add the cells B4, B8 and B12 as outputs and run 10000 iterations you will get results similar to those below:

The "Correl Example" Results

As you can see the positive correlation increases the standard deviation and variance whilst the negative correlation has the opposite effect. This effect is also shown by viewing the distributions of the output cells below.

The "Correl Example" distributions