Palisade Knowledge Base

HomeTroubleshooting@RISK for Excel: Optimization (RISKOptimizer)Correlations Ignored (RISKOptimizer 5.5.0)

5.7. Correlations Ignored (RISKOptimizer 5.5.0)

Applies to:
RISKOptimizer 5.5.0 only

Problem:
I want to see the simulated correlation of two distributions in my optimization, but the RiskCorrel( ) function does not work.

Response:
Unfortunately, there was a bug in RISKOptimizer 5.5.0. This bug was fixed in 5.5.1, and it did not affect any release of @RISK.

If you are eligible for an upgrade to a later release, you should obtain it from your Palisade sales manager.

If you are unable to upgrade, we do have a partial workaround:

To have RiskCorrel cells return values for the best simulation, after the RISKOptimizer optimization you should choose to put the best solution in the adjustable cells, and then run a simulation in @RISK. To obtain the exact same statistics in @RISK as those in RISKOptimizer, use the same random-number generator, fixed number of iterations, and fixed seed in both programs.

Random-number generator:

Fixed number of iterations:

Fixed seed:

last edited: 2012-11-22

This page was: Helpful | Not Helpful