# Manuals/calci/COVAR

COVAR (Array1,Array2)

where,

• 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 , can be numbers or can be names, arrays or references containing numbers.
• Values containing text, logical values or empty cells are ignored.
• If either or is empty, Calci displays a NaN error message.
• The number of data points in and should be same, else Calci displays a #N/A error message.

## ZOS

• The syntax is to use the COVAR function in ZOS is • and 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.
```

Covariance