RSQ function

RSQ(numbers1, numbers2) RSQ(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 square of the Pearson correlation coefficient of two sets of data.

Returns the square of the Pearson correlation coefficient of two sets of data. CORREL and PEARSON return the standard Pearson correlation coefficient.

Example

RSQ(RANDARRAY(10), RANDARRAY(10))RSQ(RANDARRAY(10); RANDARRAY(10))

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