# CORREL

## Content

This function returns the correlation coefficient of the two sets of data.

## Syntax

`CORREL(array1, array2)`

## Arguments

The two arrays of data in the arguments of this function should meet these criteria:

* The data should contain numbers, names, ranges, or references that are numeric. If some cells do not contain numeric data, they are ignored.
* The arrays should be the same size, with the same number of data points.
* The arrays should not be empty, nor should the standard deviation of their values equal zero.

## Data Types

Accepts arrays of numeric data for both arguments. Returns numeric data.

## Examples

`CORREL(C1:C10,D1:D10)`

`CORREL(R1C3:R10C3,R1C4:R10C4)`

`CORREL({5,10,15,20,25},{4,8,16,32,64})` gives the result 0.9332565253

`CORREL({73000,45000,40360},{42,70,40})` gives the result -0.3261046660