CORREL

Calculates r, the Pearson product-moment correlation coefficient of a dataset.

Syntax

CORREL(data_range1, data_range2)

data_range1

The range of cells with the dependent data. For example: A1:A20.

data_range2

The range of cells with the independent data. For example: A1:A20.

CORREL() returns 1