The CORREL function returns the correlation coefficient, the Pearson Product-Moment Correlation Coefficient, for two sets of values.
|array1||A range of cells containing a set of independent variables|
|array2||A range of cells containinga set of dependent variables|
Note: The CORREL function is the same as the PEARSON function. Both functions should produce the same results.
|2||3||8||=CORREL(A2:A6,B2:B6)||0.83205||Correlation coefficient of the two data sets in columns A and B|
Usage note: Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location’s average temperature and the use of air conditioners.
Common Function Error(s)
|Problem||What went wrong|
|#N/A||Occurs if the supplied arrays are of different lengths|
The Pearson product-moment correlation coefficient is a statistical measurement of the correlation, linear association, between two sets of values, x and y.
The equation for the correlation coefficient is:
where and are the sample means AVERAGE(array1) and AVERAGE(array2).
If the value of r is close to +1, this indicates a strong positive correlation, and if r is close to -1, this indicates a strong negative correlation.
See Wikipedia for more information on the Pearson Product-Moment Correlation Coefficient.