COVARIANCE.S()
Syntax. COVARIANCE.S(array1,array2)
Definition. This function returns the covariance of a sample, which is the average of the products of deviations for each data-point pair.
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 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.S() 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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.