Manuals/calci/CORRELATION

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


Correlation by Columns
Column1 Column2
Column1 1 1
Column2 1 1


Correlation by Rows
Row1 Row2 Row3 Row4
Row1 1 1 -1 1
Row2 1 1 -1 1
Row3 -1 -1 1 -1
Row4 1 1 -1 1