Sign up for free
Functions

CORREL

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

Parameter List

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.

Examples

CORREL() returns 1