HomeTroubleshooting@RISK for Excel: Other IssuesRiskCorrmat Ignored in F9 Recalculation

8.18. RiskCorrmat Ignored in F9 Recalculation

Applies to: @RISK 4.x–7.x

I've set up an @RISK model with a correlation matrix using the RiskCorrmat function. I've set @RISK's standard recalc mode to random. Why is there no correlation between the correlated input variables when I press the F9 key to recalculate the Excel spreadsheet?

This is by design. F9 key sampling is not controlled by the correlation matrix, because the RiskCorrmat( ) functions only become active during the actual @RISK simulation.

See also:
How @RISK Correlates Inputs

Additional keywords: Corrmat

Last edited: 2015-10-15

This page was: Helpful | Not Helpful