COVARIANCE.P()

Syntax. COVARIANCE.P(array1,array2)

Definition. This function returns the covariance of a population, which is the average of the products of deviations for each data-point pair.

Use the covariance to determine the relationship between two data sets. For example, you can determine whether a higher income is based on education.

Arguments

• array1 (required). The first cell range of integers

• array2 (required). The second cell range of integers

Note

The arguments must be numbers, names, arrays, or references that contain numbers. If an array or a reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value 0 are included.

If array1 and array2 have a different number of data points, COVARIANCE.P() returns the #N/A error. If array1 or array2 is empty, the function returns the #DIV/0! error.

See Also

You will find more information about covariances in the description of COVAR().

See Also

CORREL(), COVAR(), COVARIANCE.S(), FISHER(), FISHERINV()

Sample Files

Use the COVARIANCE.P worksheet in the Regression.xls or Regression.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.