VoseCorrMatrixU

Download a pdf copy of this help file  here

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.