Formualizer Docs
ReferenceFunctionsStatistics Functions

INTERCEPT

Returns the y-intercept of the linear regression line for paired data.

Summary

INTERCEPT fits y = m*x + b and returns b, the predicted y when x = 0.

Remarks

  • known_y and known_x must have the same numeric length.
  • Returns #N/A for mismatched lengths.
  • Returns #DIV/0! if all x values are identical.

Examples

Positive intercept from direct arrays
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Intercept from range-based linear trend
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
12

Runtime metadata

Category

Statistics

Signature

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

HYPGEOM.DIST

HYPGEOM.DIST: Returns hypergeometric probabilities for successes drawn without replacement.

KURT

Returns the sample excess kurtosis of a numeric distribution.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata