COVARIANCE.S(array1, array2)

Returns the covariance based on a sample.

array1The first array of integers.
array2The second array of integers.

Remarks

* Added in Excel 2010.
* The arguments can either be numbers, arrays or cell references.
* Any text, logical values or empty cells are ignored.
* If "array1" and "array2" do not have the same number of elements, then #N/A is returned.
* If either "array1" or "array2" is empty, then #DIV/0! is returned.
* If either "array1" or "array2" contains only 1 element, then #DIV/0! is returned.
* For the Microsoft documentation refer to support.office.com

 A
1??


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top