Home Application Office information

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

COVARIANCE.P function: Returns the covariance of the population, the average of the product deviations for each pair of data points in the two data sets Syntax: COVARIANCE.P (array1, array2)

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

Picture 1 of 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

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:

Picture 2 of 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

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

Picture 3 of 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

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

Picture 4 of 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

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

Picture 5 of 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

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

Picture 6 of 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

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

Good luck!

You've just finished reading the article "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" edited by the TipsMake team. You can save covariancep-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.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV COVARIANCE.S function - Returns the covariance pattern, the average of product deviations for each pair of data points in two data sets in Excel
NEXT » Instructions for page numbering in Word, align page numbers, delete page numbers
Read more