# CORREL function

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.

## Syntax

CORREL(array1,array2)

Argument

Description

Remarks

array1

A cell range of values.

• If an array or reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value zero are included.

• If this argument is empty, this function returns the #DIV/0! error value.

array2

A second cell range of values.

• If an array or reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value zero are included.

• If this argument is empty, this function returns the #DIV/0! error value.

## General remarks

• 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).

## Example

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.

 1 2 3 4 5 6
 A B Data Data2 3 9 2 7 4 12 5 15 6 17 Formula Description (Result) =CORREL(A2:A6,B2:B6) Correlation coefficient of the two data sets in the table (0.997054)
 Rate this content: