COVAR

This function returns the covariance, which is the average of the products of deviations for each data point pair in two sets of numbers.

Syntax

COVAR(array1, array2)

Arguments

This function has these arguments:

Remarks

Use this covariance function to determine the relationship between two sets of data. For example, you can examine whether greater income accompanies greater levels of education in a population.

The covariance is calculated as follows, where n is the size of the arrays and mu is the mean.

Examples

COVAR(J2:J5,L2:L5)

COVAR(R2C12:R15C12,R2C14:R15C14)

COVAR({7,5,6},{7,4,4}) gives the result 1

COVAR({5,10,15,20,25},{4,8,16,32,64}) gives the result 144