Formualizer Docs
ReferenceFunctionsStatistics Functions

FREQUENCY

Returns a vertical frequency distribution for numeric data across bin cutoffs.

Summary

FREQUENCY counts values into <= first bin, intermediate right-closed bins, and an overflow bucket above the final bin.

Remarks

  • Returns an array with bins + 1 rows.
  • Bins are sorted before counting.
  • If bins_array has no numeric values, result is a single count of all data points.
  • Non-numeric values in input ranges are ignored by statistical-collection rules.

Examples

Frequency buckets with two bins
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
[[2],[2],[1]]
Frequency with repeated values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
[[2],[2],[1]]

Runtime metadata

Category

Statistics

Signature

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

PURENUMERIC_ONLY

Source

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

FORECAST.LINEAR

FORECAST.LINEAR: Returns a predicted y-value at `x` from simple linear regression over known data.

GAMMA.DIST

GAMMA.DIST: Returns the gamma-distribution probability at `x` for shape `alpha` and scale `beta`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata