Manuals/calci/COVAR
COVAR (a1, a2)
Where a1 is the first cell range and a2 is the second cell range of integers.
Covariance calculates as, the average of the products of deviations for each data point pair. It is to determine the relationship between two data sets.
· Arguments can be numbers, names, arrays, or references.
· Logical values and text representations of numbers are calculated but if an array or reference argument contains text, logical values, empty cells which are ignored
· If either array1 or array2 is empty, COVAR calculates error value.
· The covariance is:
where x and y are the sample means AVERAGE(a1) and AVERAGE(a2), and n is the sample size.
Let’s see an example in (Column1 Row 1, Column2Row1)
COVAR (a1, a2)
B C
5 8
6 9
7 15
8 17
9 20
=COVAR (B2:B6, C2:C6) is 6.4
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5 | 8 | 6.4 | |
| Row2 | 6 | 9 | ||
| Row3 | 7 | 15 | ||
| Row4 | 8 | 17 | ||
| Row5 | 9 | 20 | ||
| Row6 |
