Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

CORREL

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

 

Sample Usage

CORREL(A2:A100,B2:B100)

Syntax

CORREL(data_y, data_x)

  • data_y - The array or range representing the first dataset.
  • data_x - The array or range representing the second dataset.

Examples

CORREL(A2:A100,B2:B100) returns the correlation coefficient of the two data sets in columns A and B..

 

Notes

  • Any text encountered in the data_y and data_x ranges will be ignored.
  • CORREL is synonymous with PEARSON.