Formualizer Docs
ReferenceFunctionsStatistics Functions

CORREL

Returns the Pearson correlation coefficient between two numeric arrays.

Summary

CORREL measures linear relationship strength from -1 (perfect inverse) to 1 (perfect direct).

Remarks

  • Both arrays must produce the same number of numeric values.
  • Returns #N/A when array lengths differ.
  • Returns #DIV/0! when either series has zero variance.

Examples

Perfect positive linear correlation
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Perfect negative linear correlation
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
-1

Runtime metadata

Category

Statistics

Signature

CORREL(arg1, arg2, ... argN: Number (Range))

This function accepts a repeating argument pattern (min args: 2).

Arity

min 2, max 1

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PUREREDUCTIONNUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

CONFIDENCE.T

CONFIDENCE.T: Returns the half-width of a confidence interval using a t critical value.

COVARIANCE.P

COVARIANCE.P: Returns population covariance for two paired numeric data sets.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata