Documentation/Calc Functions/COVARIANCE.S

Function name:
COVARIANCE.S

Category:
Statistical Analysis

Summary:
Returns the covariance of the product of paired deviations, for a sample of the population.

Syntax:
COVARIANCE.S(Data1; Data2)

Returns:
Returns a real number which is the sample covariance (the average of the products of deviation) for each data point pair in two data sets, Data1 and Data2.

Arguments:
Data1 is a reference to a range of cells that is considered the first data set.

Data2 is a reference to a range of cells which is considered the second data set.


 * If a cell contains text, logical values, or empty cells, then the function ignores these values.
 * If Data1 and Data2 have different number of data points then the function returns an error value.
 * If the standard deviation of Data1 and Data2 is 0 then the function returns an error value.
 * If any of the arguments is empty, or if the standard deviation of their values equals zero, COVARIANCE.S returns an error value.

Additional details:

 * For more details on COVARIANCE.S, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/COVARIANCE.P COVARIANCE.P]

[[Special:MyLanguage/Documentation/Calc_Functions/COVAR COVAR]

ODF standard:
None

Equivalent Excel functions:
COVARIANCE.S