Article updated on March 29, 2018

The CORREL function calculates the correlation between two groups of numbers.

Formula in cell B12:

=CORREL(C3:C9, D3:D9)

The value in cell B12 shows that there is a strong correlation between ice cream sales and temperature.

Excel Function Syntax

CORREL(array1, array2,…)

Arguments

array1 Required. The first set of numbers.
array2 Required. The second set of numbers.

Comments

Text, boolean and empty cells are ignored.

An error value is returned if the arguments don't contain the same number of values.