Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

CORREL function


Correlation function.

CORREL(range1,range2) returns the Pearson correlation coefficient of the data in range1 and range2.

The equation for CORREL is:

$$ \frac{ \sum_{}^{}{(x-\bar{x})(y-\bar{y})}} {\sum_{}^{}{(x-\bar{x})^2} \sum_{}^{}{(y-\bar{y})^2}} $$

The arguments range1 and range2 can be a list of numbers, cell addresses, cell ranges (such as A1:A10).

Range1 and range2 can also be vectors (column or row matrices) with the same number of elements.

Related functions