Skip to Content

COVARIANCE.P

Returns population covariance, the average of the products of deviations for each data point pair

Syntax

COVARIANCE.P(array1, array2)

Parameters

  • array1: Required. The first cell range of integers
  • array2: Required. The second cell range of integers

Example

=COVARIANCE.P(A1:A10, B1:B10)
Returns: NumberSince: Excel 2010