|
<< Click to Display Table of Contents >> RSQ (square of Pearson) |
Syntax:
RSQ(Range1, Range2)
Description:
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. These 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:
RSQ(A1:A3, B1:B3) returns 0.99436
Annotation:
RSQ is the square of PEARSON (Pearson's correlation coefficient).
See also: