Manuals/calci/CORRELATION
Jump to navigation
Jump to search
CORRELATIONDATAANALYSIS(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.
Compares two sets of data to determine if there is any relationship between them.
If array contains the text, then CORRELATIONDATAANALYSIS returns NaN.
CORRELATION
Lets see an example in (Column3, Row1)
=CORRELATIONDATAANALYSIS(R1C1:R2C2, "Columns",TRUE)
It returns the result in new sheet(5Sapce).
=CORRELATIONDATAANALYSIS(R1C1:R5C2,"Rows", TRUE)
It returns the result in new sheet(9space).
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 3 | 5Space | 5 |
| Row2 | 7 | 8 | 9 | 128 |
| Row3 | 12 | 5 | 14 | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 37 | 31 | 10023 | 168 |
| Row6 | 6 | 9Space | 1.619775 | 0.525322 |
| Column1 | Column2 | |
|---|---|---|
| Column1 | 1 | 1 |
| Column2 | 1 | 1 |
| Row1 | Row2 | Row3 | Row4 | |
|---|---|---|---|---|
| Row1 | 1 | 1 | -1 | 1 |
| Row2 | 1 | 1 | -1 | 1 |
| Row3 | -1 | -1 | 1 | -1 |
| Row4 | 1 | 1 | -1 | 1 |