COVAR

Definition: COVAR is a function that returns the covariance between two sets of data.

Syntax: =COVAR(array1, array2)

Situation: This formula is suitable when you need to find the covariance between two sets of data.

Example: If you have two sets of data in arrays A1:A5 and B1:B5, the covariance can be found using the formula =COVAR(A1:A5, B1:B5), which returns the covariance between the two sets of data.