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.