CORREL function

CORREL(Numbers1, Numbers2) CORREL(Numbers1; Numbers2)

Numbers1

{ Number }

The first set of values. This array must have the same size as the other array parameter.

Numbers2

{ Number }

The second set of values. This array must have the same size as the other array parameter.

Returns

Number

The Pearson correlation coefficient of two sets of data.

Returns the Pearson correlation coefficient of two sets of data. CORREL is equivalent to PEARSON. RSQ returns the square of the Pearson correlation coefficient of two sets of data.

Example

CORREL(RANDARRAY(10), RANDARRAY(10))CORREL(RANDARRAY(10); RANDARRAY(10))

Returns the Pearson correlation coefficient of two sets of random data.