- Picture and text skills
- Case
Returns the sample covariance, which is the average of the products of the deviations for each pair of data points in the two data sets.
Grammar
COVARIANCE.S(array1,array2)
COVARIANCE.S function syntax has the following parameters:
▪Array1 Required. The first cell range of integers.
▪Array2 Required. The second cell range of integers.
Remarks
▪Argument must be a number, or a name, array, or reference containing a number.
▪ If the array or reference parameter contains text, logical values, or blank cells, these values will be ignored; however, cells containing zero values will be counted.
▪ If array1 and array2 have different numbers of data points, COVARIANCE.S returns the error value #N/A.
▪ Covariance if array1 or array2 is empty, or contains only 1 data point. S returns the #DIV/0! error value.
Example
Formula | Description | Results |
=COVARIANCE.S({2,4,8},{5,11,12}) | The sample covariance of the data points entered as an array in the function. | 9.666666667 |
2 | 5 | |
4 | 11 | |
8 | 1.2 | |
Formula | Description | Results |
=COVARIANCE.S(A3:A5,B3:B5) | Sample covariance of the same data points entered as a range of cells in the function. | 9.666666667 |
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/Covariance-S-han-shu-shi-yong-fang-fa.html
评论列表(196条)
测试