Formualizer Docs
ReferenceFunctionsStatistics Functions

PEARSON

Returns the Pearson correlation coefficient between two paired numeric arrays.

Summary

PEARSON reports linear association on a normalized scale from -1 to 1.

Remarks

  • Arrays must contain the same number of numeric observations.
  • Returns #DIV/0! when either array has zero variance.
  • Positive values indicate positive linear association; negative values indicate inverse association.
  • Pairing and shape mismatches return spreadsheet errors from paired-array validation.

Examples

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

Runtime metadata

Category

Statistics

Signature

PEARSON(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

NORM.S.INV

NORM.S.INV: Returns the z-score whose standard normal cumulative probability matches `probability`.

PERCENTILE.EXC

PERCENTILE.EXC: Returns the k-th percentile of a data set using exclusive interpolation.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata