COVAR Function Explained

The COVAR function in Microsoft Excel calculates the covariance between two sets of numbers. It takes two arguments, array1 and array2, which are the two sets of numbers to be compared. The result is a single number that represents the covariance between the two sets of numbers.

COVAR Function Syntax

COVAR(array1, array2)

  • array1: The first array or range of data.
  • array2: The second array or range of data.