COVARIANCE.P function - The function returns the covariance of a set, the product of the average of degrees of instruction for each pair of data points in Excel

The following article introduces you to the COVARIANCE.P function - one of the functions in the statistical function group is very popular in Excel.

COVARIANCE.P function - The function returns the covariance of a set, the product of the average of degrees of instruction for each pair of data points in Excel Picture 1

Description: Returns the covariance of the population, the average of the deviations for each pair of data points in the two data sets.

Syntax: COVARIANCE.P (array1, array2)

Inside:

- array1: The first range contains integers that want to calculate the variance, is a required parameter.

- array2: The second range contains the integers that want to calculate the variance, is a required parameter.

Attention:

- The argument must be either a number or a reference array that contains numbers.

- If the reference argument or array contains text or logical values ​​or empty cells will be ignored.

- If array1 and array2 have different data points -> the function returns the # N / A error value

- If 1 of the 2 arrays is empty -> the function returns the # DIV / 0 error value

- Functions that perform calculations based on formulas:

[Covleft ({X, Y} right) = frac {{sum {left ({x - overline x} right) left ({y - overline y} right)}}} {n}]

Inside:

({overline x}) and ({overline y}) are sample mean AVERAGE (array1) and AVERAGE (array2 ) and n are sample sizes.

For example:

Calculate the covariance, the average of the product of deviations of each data point pair of the two data sets in the following table:

COVARIANCE.P function - The function returns the covariance of a set, the product of the average of degrees of instruction for each pair of data points in Excel Picture 2

- In the cell to calculate enter the formula : = COVARIANCE.P (B6: B10, C6: C10)

COVARIANCE.P function - The function returns the covariance of a set, the product of the average of degrees of instruction for each pair of data points in Excel Picture 3

- Press Enter -> covariance, the average of the product of deviations of each data point pair of two data sets is:

COVARIANCE.P function - The function returns the covariance of a set, the product of the average of degrees of instruction for each pair of data points in Excel Picture 4

- Where 1 of 2 arrays is blank -> the function returns the # DIV / 0 error value

COVARIANCE.P function - The function returns the covariance of a set, the product of the average of degrees of instruction for each pair of data points in Excel Picture 5

- Where the number of data points of the two arrays is not the same -> the function returns the # N / A error value .

COVARIANCE.P function - The function returns the covariance of a set, the product of the average of degrees of instruction for each pair of data points in Excel Picture 6

Above are instructions and some specific examples when using the COVARIANCE.P function in Excel.

Good luck!