RSQ (square of Pearson)

<< Click to Display Table of Contents >>

RSQ (square of Pearson)

Syntax:

RSQ(Range1, Range2)

Description:

This returns the determination coefficient of two data sets.

This coefficient is a measure of the strength of the linear relationship between data sets. The closer it is to 1, the greater the correlation.

Range1 and Range2 are cell references to the two data sets. They must contain numbers. Empty cells, text and logical values are ignored.

The data sets must have the same number of values, otherwise the function returns a #N/A error value.

Example:

If A1:A3 contains the values 2, 5, 3 and B1:B3 contains 2, 7, 4, the following applies:

RSQ(A1:A3, B1:B3) returns 0.99436

Additional info:

RSQ is the square of PEARSON (Pearson's correlation coefficient).

See also:

PEARSON