|
<< Click to Display Table of Contents >> CORREL (correlation coefficient) |
Syntax:
CORREL(Range1, Range2)
Description:
Returns the correlation coefficient of two data sets.
The correlation coefficient is a measure of the relationship between two data sets.
Range1 and Range2 are cell references to the two data sets. 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:
CORREL(A1:A3, B1:B3) returns 0.99718
See also: