# CORREL

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

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

## Version Available

This function is available in product version 1.0 or later.

## See Also

[COVAR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionCOVAR) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)