Formualizer Docs
ReferenceFunctionsStatistics Functions

SLOPE

Returns the slope of the linear regression line for paired data.

Summary

SLOPE fits y = m*x + b and returns m, the rate of change in y per unit of x.

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 slope from direct arrays
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2
Negative slope from ranges
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
-2

Runtime metadata

Category

Statistics

Signature

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

SKEW

Returns the sample skewness of a numeric distribution.

SMALL

Returns the k-th smallest value in a data set.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata