Formualizer Docs
ReferenceFunctionsStatistics Functions

LOGEST

LOGEST: Returns parameters for an exponential model fitted to known data.

Summary

LOGEST fits y = b * m^x and returns either [m, b] or an expanded statistics matrix.

Remarks

  • All known y-values must be strictly greater than 0.
  • known_x defaults to 1..n when omitted.
  • const controls whether b is fitted (TRUE by default).
  • stats=TRUE returns a 5x2 statistics block; otherwise returns 1x2.

Examples

Exponential base and intercept
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
[[2,1]]
Alternative growth series
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
[[2,1.5]]

Runtime metadata

Category

Statistics

Signature

LOGEST(arg1…: Number (Range))

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

Arity

min 1, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PURENUMERIC_ONLY

Source

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

LINEST

LINEST: Returns linear-regression coefficients and optional fit statistics.

LOGNORM.DIST

LOGNORM.DIST: Returns the log-normal probability at `x` as either a cumulative value or density.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata