VoseSimCorrelation | Vose Software


See also: VoseSimCorrelationMatrix, VoseSimCofV, VoseSimCVARp, VoseSimCVARx, VoseSimKurtosis, VoseSimMax, VoseSimMean, VoseSimMin, VoseSimMoments, VoseSimMSE, VoseSimPercentile, VoseSimProbability, VoseSimMeanDeviation, VoseSimSemiStdev, VoseSimSemiVariance,  VoseSimSkewness, VoseSimStdev, VoseSimTable, VoseSimVariance, VoseSimValue

VoseSimCorrelation(Cell Reference1, Cell Reference2, Type, Simulation number)




Example model

This function returns the correlation coefficient between two cells during simulation.

  • Cell Reference 1 -  Should be a valid reference to a spreadsheet cell.

  • Cell Reference 2 -  Should be a valid reference to a spreadsheet cell.

  • Type -  Type = 0 gives Spearman, Type = 1 gives Pearson.

  • Simulation number -  Optional simulation number parameter. Must be an integer>=1. Equals 1 if omitted.



Monte Carlo simulation in Excel. Learn more

Spreadsheet risk analysis modeling


Adding risk and uncertainty to your project schedule. Learn more

Project risk analysis


Enterprise Risk Management software (ERM)

Learn more about our enterprise risk analysis management software tool, Pelican

Enterprise risk management software introduction