Manuals/calci/COVARIANCE
Jump to navigation
Jump to search
COVARIANCENDATAANALYSIS(Array,GroupBy, NewTableFlag)
where,
Array - Input range should be one or more blocks.
GroupBy - Either groupby rows or columns.
NewTableFlag - is the TRUE or FALSE.If set as TRUE,the result in new sheet.If NewTableFlag is omitted, it assumed to be FALSE.
Calculates the average of the product of deviatons of values from the means of each data set.
If array contains the text, then COVARIANCE returns NaN.
COVARIANCE
Lets see an example in (Column3, Row1)
=COVARIANCEDATAANALYSIS(R1C1:R4C2, "Columns",TRUE)
It returns the result in new sheet(2Sapce).
=COVARIANCEDATAANALYSIS(R1C1:R5C2,"Rows", TRUE)
It returns the result in new sheet(9space).
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5 | 3 | 2Space | 5 |
| Row2 | 7 | 8 | 9 | 128 |
| Row3 | 12 | 8 | 14 | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 41 | 34 | 10023 | 168 |
| Row6 | 6 | 9Space | 1.619775 | 0.525322 |
| Column1 | Column2 | |
|---|---|---|
| Column1 | 21.6875 | 23.4375 |
| Column2 | 23.4375 | 29.6875 |
| Row1 | Row2 | Row3 | Row4 | |
|---|---|---|---|---|
| Row1 | 1 | -0.5 | 2 | -0.5 |
| Row2 | -0.5 | 0.25 | -1 | 0.25 |
| Row3 | 2 | -1 | 4 | -1 |
| Row4 | -0.5 | 0.25 | -1 | 0.25 |