Buzz
COVAR Function calculates the variance and covariance for each pair of data points in two different data sets. The computed covariance values are used to determine the relationship between the specified data sets. This function can be utilized to assess the correlation between education level and income.
COVAR Function and Examples
How to Use COVAR Function in Excel - Illustrated Example
Syntax: COVAR(array1,array2)
Where:
- Array1 : Mandatory – The range of the first cell containing integers.
- Array2 : Mandatory – The range of the second cell containing integers.
Consider an Example
Input your actual values corresponding to the function parameters in Excel cells, in this example, two arrays of 10 different values as shown in the image:
Enter the formula in cell C8. The calculated result of the function is 1.36:
So, now you know how to use the COVAR function in Excel. Note that when calculating with the COVAR function, the number of data points must be equal between the two data arrays, and each data array must not be empty for accurate computation.
