MCOVAR macro

Returns a covariance matrix that measures the covariance between two or more data sets.

If this function is not available, you must install the Analysis ToolPak add-in.

Syntax

MCOVAR(inprng, outrng, grouped, labels)

MCOVAR?(inprng, outrng, grouped, labels)

Inprng    is the input range.

Outrng    is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Grouped    is a text character that indicates whether the data in the input range is organized by row or column.

 

Labels    is a logical value that describes where the labels are located in the input range, as shown in the following table:

Labels Grouped Labels are in
TRUE "C" First row of the input range
TRUE "R" First column of the input range
FALSE or omitted (ignored) No labels. All cells in the input range are data.

Related Function

MCORREL   Returns the correlation coefficient of two or more data sets that are scaled to be independent of the unit of measurement

Return to index