﻿ CORREL | Spread.NET 14 Formula Reference
Formula Functions / Functions A to C / CORREL
In This Topic
CORREL
In This Topic

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.