VCORREL function

Description

VCORREL(variable1,variable2[,filter]) returns the Pearson correlation coefficient of 2 variables. An optional filter can be specified.

The equation for VCORREL is:

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

Note

This function calculates a statistic on a variable. Be careful when you use this function in cells of the columns that correspond to the variable, because this actually adds a value to the variable which can lead to unexpected and faulty results. You can exclude the cell to avoid this.

Related functions

VSLOPE function
VINTERCEPT function
Statistical spreadsheet functions on variables.