Excel COVARIANCE.P function
The Excel COVARIANCE.P function returns the population variance of two data sets which is used to determine the relationship between two data sets.
Syntax and arguments
1. Array 1 and array 2 must be numbers, names, arrays or references that contain numbers.
2. Array 1 and array 2 must be equal in length, otherwise, COVARIANCE.P function returns #N/A error value.
3. If array 1 or array 2 contains text(s) or logical values or empty cells, COVARIANCE.P function will ignore them.
4. If either array 1 or array 2 is empty, the COVARIANCE.P function returns #DIV/0! error value.
5. The covariance is:
Where x ̅ and y ̅ are the sample means AVERAGE(array1) and AVERAGE(array2), n is the sample size.
Excel 2010 and later versions.
Usage and Examples
Here are two arrays in range B3:B8 and C3:C8, to get the relative population covariance, please, use the formula as this:
Press Enter key.
Excel BETA.DIST Function
The Excel BETA.DIST function (Excel 2013) returns the beta distribution which is usually used to study the percentage variation of something across samples.
Excel BETADIST Function
The Excel BETADIST function (Excel 2010) returns the beta distribution which is usually used to study the percentage variation of something across samples.
Excel NORM.S.DIST Function
The NORM.S.DIST calculates and returns the standard normal cumulative distribution function or probability density function of a value for an arithmetic mean of 0 and standard deviation of 1
Excel NORM.S.INV Function
The NORM.S.INV calculates and returns the inverse of the standard normal cumulative distribution that has an arithmetic mean of 0 and standard deviation of 1 with a given probability.