Manuals/calci/COVAR

COVAR (Array1,Array2)

where,

$Array1$ is the first array of integers or reference to the cells containing array
is the second array of integers or reference to the cells containing array
- COVAR(), returns covariance, the average of the products of paired deviations.

Description

COVAR (Array1,Array2)

COVAR is used to determine the relationship between two data sets.
Arguments $Array1$ , $Array2$ can be numbers or can be names, arrays or references containing numbers.
Values containing text, logical values or empty cells are ignored.
If either $Array1$ or $Array2$ is empty, Calci displays a NaN error message.
The number of data points in $Array1$ and $Array2$ should be same, else Calci displays a #N/A error message.

The syntax is to use the COVAR function in ZOS is
- $Array1$ and $Array2$ are the set of values to find the Covariance.
For e.g.,COVAR([10,20,15,17,19],[12,22,31,16,45])
COVAR([50..57],[17..24])

=COVAR(A2:A6,B2:B6) : Returns 4 as the output.
=COVAR(A2:A5,[12,13,14,15]) : Returns 2.5 as the output.