VoseSimCorrelation

Download a pdf copy of this help file  here

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.