PEARSON (Numbers1, Numbers2) PEARSON (Numbers1; Numbers2)

Numbers1

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

Numbers2

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

Returns

Number Number

The Pearson correlation coefficient of two sets of data.

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

Example

PEARSON ( RANDARRAY (10), RANDARRAY (10))
PEARSON ( RANDARRAY (10); RANDARRAY (10))

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

fxEngine Shell Want this in your own terminal? A standalone version is coming. Get notified.
Loading fxEngine Shell