Skip to main content

COVARIANCE.P function

The COVARIANCE.P function is one of the statistical functions. It is used to return population covariance, the average of the products of deviations for each data point pair in two data sets; use covariance to determine the relationship between two data sets.

Syntax​

COVARIANCE.P(array1, array2)

The COVARIANCE.P function has the following argument:

ArgumentDescription
array1(2)The selected ranges of cells with the same number of elements.

Notes​

If array1(2) contains text, logical values, or empty cells, the function will ignore those values, but treat the cells with the zero values.

How to apply the COVARIANCE.P function.

Examples​

The figure below displays the result returned by the COVARIANCE.P function.

COVARIANCE.P Function