Skip to content

CORREL

StatisticalExcel 2007

The correlation coefficient between two data sets (−1 to 1).

Syntax

CORREL(array1, array2)

Examples

=CORREL(ad_spend, revenue)

→ 0.87

Related functions

SLOPEINTERCEPTFORECAST.LINEAR

More Statistical functions

AVEDEVAVERAGEAVERAGEAAVERAGEIFAVERAGEIFSBETA.DISTBETA.INVBINOM.DISTBINOM.DIST.RANGEBINOM.INVCHISQ.DISTCHISQ.DIST.RT

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.