Manuals/calci/COVARIANCEDATAANALYSIS

COVARIANCEDATAANALYSIS (Array,GroupBy,NewTableFlag)

where,

$Array$ is array of integers or reference to the cells containing array,
$GroupBy$ is a method that performs the analysis by Columns or Rows,
is a flag that determines how the output should be displayed.
- COVARIANCEDATAANALYSIS() calculates the average of product of deviations of values from the means of each data set.

Description

COVARIANCEDATAANALYSIS(Array, GroupBy, NewTableFlag)

Covariance is a method used to determine the relationship between two data sets.
$Array$ can be numbers or can be names, arrays or references containing numbers.
Values containing text, logical values or empty cells are ignored.
Argument $GroupBy$ can be "Rows" or "Columns".
$NewTableFlag$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be TRUE.
If $NewTableFlag$ is TRUE, output is displayed on a new ZSpace cube. If $NewTableFlag$ is FALSE, output is displayed on the same spreadsheet where command is written.
If data is invalid, Calci displays NaN error message.

The syntax is to calculate this function in ZOS is $COVARIANCEDATAANALYSIS(2D-Array,GroupBy,NewTableFlag)$
$GroupBy$ is a method that performs the analysis by Columns or Rows,
$NewTableFlag$ is a flag that determines how the output should be displayed which is either TRUE or FALSE.
For e.g., COVARIANCEDATAANALYSIS([[10,13,16,19,22],[29,27,34,41,56]],"columns",true)
COVARIANCEDATAANALYSIS([[33..39],[57..63]],"columns",false)

Consider the following table with two arrays as input data.

=COVARIANCEDATAANALYSIS(A2:B5,"Columns",TRUE)
=COVARIANCEDATAANALYSIS(A2:B6,"Rows",TRUE)

Output for the above examples is displayed respectively.

Covariance by Columns
	Column1	Column2
Column1	21.6875	23.4375
Column2	23.4375	29.6875