# 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 |