CORREL function
Description
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.