Correlation Coefficient When Applying Excel's CORREL( ) function to the Simulation Data

In the correlation matrix of @RISK, rank-order correlation coefficients (Spearman) are supplied.

Excel calculates product-moment correlation coefficients (Pearson).

In @RISK 5.5.0 and later, you can use the RiskCorrel( ) function to show the Spearman coefficient after a simulation, and it should be close to what you specified.

 

Related Article:

How Risk Correlates Inputs Differently From Excel (includes a downloadable example)