Manuals/calci/COVAR

COVAR (Array1,Array2)

where,

• $Array1$ is the first array of integers or reference to the cells containing array
• $Array2$ 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.

ZOS

• The syntax is to use the COVAR function in ZOS is $COVAR(Array1,Array2)$
  • $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])

Examples

Array 1	Array 2
2	21
4	22
6	23
8	24
10	25

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

Related Videos

Covariance

See Also

• COVARIANCE

References

• Covariance

• List of Main Z Functions

• Z3 home