CORREL

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

Sample usage

CORREL(A2:A100,B2:B100)

Syntax

CORREL(data_y, data_x)

• data_y – The range representing the array or matrix of dependent data.

• data_x – The range representing the array or matrix of independent data.

Notes

• Any text encountered in the value arguments will be ignored.

• CORREL is synonymous with PEARSON.

See also

STEYX: Calculates the standard error of the predicted y-value for each x in the regression of a data set.

SLOPE: Calculates the slope of the line resulting from linear regression of a data set.

RSQ: Calculates the square of r, the Pearson product-moment correlation coefficient of a data set.

PEARSON: Calculates r, the Pearson product-moment correlation coefficient of a data set.

INTERCEPT: Calculates the y-value at which the line resulting from linear regression of a data set will intersect the y-axis (x=0).

FORECAST: Calculates the expected y-value for a specified x based on a linear regression of a data set.

FISHERINV: Returns the inverse Fisher transformation of a specified value.

FISHER: Returns the Fisher transformation of a specified value.

COVAR: Calculates the covariance of a data set.

Examples