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

🍪

We use cookies to enhance your user experience and analyze website performance. You can revoke consent anytime. Learn more.