VoseCorrMatrixU | Vose Software


See also: VoseCorrMatrix




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.



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