VoseCorrMatrixU

See also: VoseCorrMatrix

=VoseCorrMatrixU({DataRange},DataInRows)

 

 

Example model

This function is an array function that simulates the uncertainty of the rank order correlation matrix of a data set: when we have a rather small data set there will be some uncertainty that the calculated correlation coefficients in the matrix are truly representative of the underlying reality. The ModelRisk function VoseCorrMatrixU simulates values from the joint uncertainty distribution of the matrix.

  • {DataRange} - the array of cells that contain the data.

  • DataInRows - an optional boolean parameter that should be set to 1 if the variables in DataRange are listed by row for each variable.

The output of the function VoseCorrMatrixU is an n x n array where n is the number of variables in the data set. A new correlation matrix will be calculated on each spreadsheet recalculation.

To return just a static estimate of the correlation matrix use the function VoseCorrMatrix.

 

ModelRisk

Monte Carlo simulation in Excel. Learn more

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Navigation

FREE MONTE CARLO SIMULATION SOFTWARE

For Microsoft Excel

Download your free copy of ModelRisk Basic today. Professional quality risk modeling software and no catches

Download ModelRisk Basic now

FREE PROJECT RISK SOFTWARE

For Primavera & Microsoft Project

Download your free copy of Tamara Basic today. Professional quality project risk software and no catches.

Download Tamara Basic now
-->