Returns the correlation coefficient of the array1 and array2 cell ranges. 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.
A cell range of values.
A second cell range of values.
If the arguments have a different number of data points, this function returns the #N/A error value.
If s (the standard deviation) of array1 and array2's values equals zero, CORREL returns the #DIV/0! error value.
The equation for the correlation coefficient is:
where x and y are the sample means AVERAGE(array1) and AVERAGE(array2).
To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.