Statistical functions

This page lists the 92 functions of the statistical family. Taxonomy/source: Statistical functions. The formula function contract has every family, the engine builds, and the evaluation limits.

Functions

Find a function

Available in

All functions

Function (aliases)	Engine	Contract
`AVERAGEAVG`	Default + full	incumbent Signature: `optional-variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`MIN`	Default + full	incumbent Signature: `optional-variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`MAX`	Default + full	incumbent Signature: `optional-variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`COUNT`	Default + full	incumbent Signature: `optional-variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`COUNTA`	Default + full	incumbent Signature: `optional-variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`COUNTIF`	Default + full	incumbent Signature: `criteria-one` Semantics: `criteria` Dialect: `excel-documented` Implementation: `implemented-assisted`
`COUNTIFS`	Default + full	incumbent Signature: `criteria-many` Semantics: `criteria` Dialect: `excel-documented` Implementation: `implemented-assisted`
`AVERAGEIF`	Default + full	incumbent Signature: `sumif` Semantics: `criteria` Dialect: `excel-documented` Implementation: `implemented-assisted`
`AVERAGEIFS`	Default + full	incumbent Signature: `sumifs` Semantics: `criteria` Dialect: `excel-documented` Implementation: `implemented-assisted`
`MEDIAN`	Default + full	required target Signature: `variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`MODE.SNGL`	Default + full	required target Signature: `variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`LARGE`	Default + full	required target Signature: `value-k` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`SMALL`	Default + full	required target Signature: `value-k` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`RANK.EQ`	Default + full	required target Signature: `rank` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`PERCENTILE.INC`	Default + full	required target Signature: `percentile` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`QUARTILE.INC`	Default + full	required target Signature: `percentile` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`STDEV.S`	Default + full	required target Signature: `variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`STDEV.P`	Default + full	required target Signature: `variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`VAR.S`	Default + full	required target Signature: `variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`VAR.P`	Default + full	required target Signature: `variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`GEOMEAN`	Default + full	required target Signature: `variadic-values` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`CORREL`	Default + full	required target Signature: `pair-arrays` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`COVARIANCE.S`	Default + full	required target Signature: `pair-arrays` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`COVARIANCE.P`	Default + full	required target Signature: `pair-arrays` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`COUNTBLANK`	Default + full	required target Signature: `unary-value` Semantics: `aggregate` Dialect: `excel-documented` Implementation: `implemented-assisted`
`MAXIFS`	Default + full	required target Signature: `sumifs` Semantics: `criteria` Dialect: `excel-documented` Implementation: `implemented-assisted`
`MINIFS`	Default + full	required target Signature: `sumifs` Semantics: `criteria` Dialect: `excel-documented` Implementation: `implemented-assisted`
`NORM.DIST`	Full only	optional analysis Signature: `norm-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`NORM.INV`	Full only	optional analysis Signature: `norm-inv` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`NORM.S.DIST`	Full only	optional analysis Signature: `norm-s-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`NORM.S.INV`	Full only	optional analysis Signature: `unary-number` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`T.DIST`	Full only	optional analysis Signature: `t-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`T.DIST.2T`	Full only	optional analysis Signature: `distribution-tail` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`T.DIST.RT`	Full only	optional analysis Signature: `distribution-tail` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`T.INV`	Full only	optional analysis Signature: `distribution-inverse` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`T.INV.2T`	Full only	optional analysis Signature: `distribution-inverse` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`CHISQ.DIST`	Full only	optional analysis Signature: `t-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`CHISQ.DIST.RT`	Full only	optional analysis Signature: `distribution-tail` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`CHISQ.INV`	Full only	optional analysis Signature: `distribution-inverse` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`CHISQ.INV.RT`	Full only	optional analysis Signature: `distribution-inverse` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`F.DIST`	Full only	optional analysis Signature: `f-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`F.DIST.RT`	Full only	optional analysis Signature: `f-tail` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`F.INV`	Full only	optional analysis Signature: `f-inverse` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`F.INV.RT`	Full only	optional analysis Signature: `f-inverse` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`BINOM.DIST`	Full only	optional analysis Signature: `binom-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`POISSON.DIST`	Full only	optional analysis Signature: `poisson-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`EXPON.DIST`	Full only	optional analysis Signature: `expon-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`GAMMA`	Full only	optional analysis Signature: `unary-number` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`GAMMALN`	Full only	optional analysis Signature: `unary-number` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`GAMMA.DIST`	Full only	optional analysis Signature: `gamma-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`GAMMA.INV`	Full only	optional analysis Signature: `gamma-inverse` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`BETA.DIST`	Full only	optional analysis Signature: `beta-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`BETA.INV`	Full only	optional analysis Signature: `beta-inverse` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`LOGNORM.DIST`	Full only	optional analysis Signature: `lognorm-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`LOGNORM.INV`	Full only	optional analysis Signature: `lognorm-inverse` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`WEIBULL.DIST`	Full only	optional analysis Signature: `weibull-dist` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`CONFIDENCE.NORM`	Full only	optional analysis Signature: `confidence` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`CONFIDENCE.T`	Full only	optional analysis Signature: `confidence` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`STANDARDIZE`	Full only	optional analysis Signature: `standardize` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`FISHER`	Full only	optional analysis Signature: `unary-number` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`FISHERINV`	Full only	optional analysis Signature: `unary-number` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`PHI`	Full only	optional analysis Signature: `unary-number` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`GAUSS`	Full only	optional analysis Signature: `unary-number` Semantics: `analysis-distributions` Dialect: `analysis-distributions` Implementation: `analysis-distributions`
`AVEDEV`	Full only	optional analysis Signature: `variadic-values` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`DEVSQ`	Full only	optional analysis Signature: `variadic-values` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`HARMEAN`	Full only	optional analysis Signature: `variadic-values` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`KURT`	Full only	optional analysis Signature: `variadic-values` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`SKEW`	Full only	optional analysis Signature: `variadic-values` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`SKEW.P`	Full only	optional analysis Signature: `variadic-values` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`TRIMMEAN`	Full only	optional analysis Signature: `trim-mean` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`PERCENTILE.EXC`	Full only	optional analysis Signature: `percentile` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`QUARTILE.EXC`	Full only	optional analysis Signature: `percentile` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`PERCENTRANK.INC`	Full only	optional analysis Signature: `percent-rank` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`PERCENTRANK.EXC`	Full only	optional analysis Signature: `percent-rank` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`RANK.AVG`	Full only	optional analysis Signature: `rank` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`PEARSON`	Full only	optional analysis Signature: `pair-arrays` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`RSQ`	Full only	optional analysis Signature: `known-y-x` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`SLOPE`	Full only	optional analysis Signature: `known-y-x` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`INTERCEPT`	Full only	optional analysis Signature: `known-y-x` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`STEYX`	Full only	optional analysis Signature: `known-y-x` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`FORECAST.LINEARFORECAST`	Full only	optional analysis Signature: `forecast` Semantics: `analysis-descriptive` Dialect: `analysis-descriptive` Implementation: `analysis-descriptive`
`FREQUENCY`	Full only	optional analysis Signature: `frequency` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`
`MODE.MULT`	Full only	optional analysis Signature: `variadic-values-array` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`
`GROWTH`	Full only	optional analysis Signature: `regression-predict` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`
`LINEST`	Full only	optional analysis Signature: `regression-fit` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`
`LOGEST`	Full only	optional analysis Signature: `regression-fit` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`
`PERCENTILE`	Full only	optional analysis Signature: `percentile` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`
`PERCENTRANK`	Full only	optional analysis Signature: `percent-rank` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`
`PROB`	Full only	optional analysis Signature: `probability-range` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`
`QUARTILE`	Full only	optional analysis Signature: `percentile` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`
`RANK`	Full only	optional analysis Signature: `rank` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`
`TREND`	Full only	optional analysis Signature: `regression-predict` Semantics: `analysis-regression` Dialect: `analysis-regression` Implementation: `analysis-regression`

Signature profiles

Argument order, required/default state, accepted shapes, repetition, and return shape come directly from the inventory.

Signature: optional-variadic-values

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`value`	no	none	`scalar`, `range`, `array`, `reference`	`zero-or-more`

Signature: criteria-one

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`range`	yes	none	`range`, `array`, `reference`	`once`
`criteria`	yes	none	`scalar`, `reference`	`once`

Signature: criteria-many

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`rangeAndCriteria`	yes	none	`scalar`, `range`, `array`, `reference`	`paired`

Signature: sumif

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`range`	yes	none	`range`, `array`, `reference`	`once`
`criteria`	yes	none	`scalar`, `reference`	`once`
`sumRange`	no	range	`range`, `array`, `reference`	`once`

Signature: sumifs

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`sumRange`	yes	none	`range`, `array`, `reference`	`once`
`rangeAndCriteria`	yes	none	`scalar`, `range`, `array`, `reference`	`paired`

Signature: variadic-values

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`value`	yes	none	`scalar`, `range`, `array`, `reference`	`one-or-more`

Signature: value-k

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`array`	yes	none	`range`, `array`, `reference`	`once`
`k`	yes	none	`scalar`, `reference`	`once`

Signature: rank

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`number`	yes	none	`scalar`, `reference`	`once`
`reference`	yes	none	`range`, `array`, `reference`	`once`
`order`	no	0	`scalar`, `reference`	`once`

Signature: percentile

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`array`	yes	none	`range`, `array`, `reference`	`once`
`fraction`	yes	none	`scalar`, `reference`	`once`

Signature: pair-arrays

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`array1`	yes	none	`range`, `array`, `reference`	`once`
`array2`	yes	none	`range`, `array`, `reference`	`once`

Signature: unary-value

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`value`	yes	none	`scalar`, `range`, `array`, `reference`	`once`

Signature: norm-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`mean`	yes	none	`scalar`, `reference`	`once`
`standardDeviation`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`

Signature: norm-inv

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`probability`	yes	none	`scalar`, `reference`	`once`
`mean`	yes	none	`scalar`, `reference`	`once`
`standardDeviation`	yes	none	`scalar`, `reference`	`once`

Signature: norm-s-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`z`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`

Signature: unary-number

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`number`	yes	none	`scalar`, `reference`	`once`

Signature: t-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`degreesFreedom`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`

Signature: distribution-tail

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`degreesFreedom`	yes	none	`scalar`, `reference`	`once`

Signature: distribution-inverse

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`probability`	yes	none	`scalar`, `reference`	`once`
`degreesFreedom`	yes	none	`scalar`, `reference`	`once`

Signature: f-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`degreesFreedom1`	yes	none	`scalar`, `reference`	`once`
`degreesFreedom2`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`

Signature: f-tail

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`degreesFreedom1`	yes	none	`scalar`, `reference`	`once`
`degreesFreedom2`	yes	none	`scalar`, `reference`	`once`

Signature: f-inverse

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`probability`	yes	none	`scalar`, `reference`	`once`
`degreesFreedom1`	yes	none	`scalar`, `reference`	`once`
`degreesFreedom2`	yes	none	`scalar`, `reference`	`once`

Signature: binom-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`successes`	yes	none	`scalar`, `reference`	`once`
`trials`	yes	none	`scalar`, `reference`	`once`
`probability`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`

Signature: poisson-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`mean`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`

Signature: expon-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`lambda`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`

Signature: gamma-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`alpha`	yes	none	`scalar`, `reference`	`once`
`beta`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`

Signature: gamma-inverse

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`probability`	yes	none	`scalar`, `reference`	`once`
`alpha`	yes	none	`scalar`, `reference`	`once`
`beta`	yes	none	`scalar`, `reference`	`once`

Signature: beta-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`alpha`	yes	none	`scalar`, `reference`	`once`
`beta`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`
`lower`	no	0	`scalar`, `reference`	`once`
`upper`	no	1	`scalar`, `reference`	`once`

Signature: beta-inverse

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`probability`	yes	none	`scalar`, `reference`	`once`
`alpha`	yes	none	`scalar`, `reference`	`once`
`beta`	yes	none	`scalar`, `reference`	`once`
`lower`	no	0	`scalar`, `reference`	`once`
`upper`	no	1	`scalar`, `reference`	`once`

Signature: lognorm-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`mean`	yes	none	`scalar`, `reference`	`once`
`standardDeviation`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`

Signature: lognorm-inverse

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`probability`	yes	none	`scalar`, `reference`	`once`
`mean`	yes	none	`scalar`, `reference`	`once`
`standardDeviation`	yes	none	`scalar`, `reference`	`once`

Signature: weibull-dist

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`alpha`	yes	none	`scalar`, `reference`	`once`
`beta`	yes	none	`scalar`, `reference`	`once`
`cumulative`	yes	none	`scalar`, `reference`	`once`

Signature: confidence

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`alpha`	yes	none	`scalar`, `reference`	`once`
`standardDeviation`	yes	none	`scalar`, `reference`	`once`
`size`	yes	none	`scalar`, `reference`	`once`

Signature: standardize

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`mean`	yes	none	`scalar`, `reference`	`once`
`standardDeviation`	yes	none	`scalar`, `reference`	`once`

Signature: trim-mean

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`array`	yes	none	`range`, `array`, `reference`	`once`
`percent`	yes	none	`scalar`, `reference`	`once`

Signature: percent-rank

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`array`	yes	none	`range`, `array`, `reference`	`once`
`x`	yes	none	`scalar`, `reference`	`once`
`significance`	no	3	`scalar`, `reference`	`once`

Signature: known-y-x

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`knownYs`	yes	none	`range`, `array`, `reference`	`once`
`knownXs`	yes	none	`range`, `array`, `reference`	`once`

Signature: forecast

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`x`	yes	none	`scalar`, `reference`	`once`
`knownYs`	yes	none	`range`, `array`, `reference`	`once`
`knownXs`	yes	none	`range`, `array`, `reference`	`once`

Signature: frequency

Return shape: array.

Argument	Required	Default	Accepts	Repetition
`data`	yes	none	`range`, `array`, `reference`	`once`
`bins`	yes	none	`range`, `array`, `reference`	`once`

Signature: variadic-values-array

Return shape: array.

Argument	Required	Default	Accepts	Repetition
`value`	yes	none	`scalar`, `range`, `array`, `reference`	`one-or-more`

Signature: regression-predict

Return shape: array.

Argument	Required	Default	Accepts	Repetition
`knownY`	yes	none	`range`, `array`, `reference`	`once`
`knownX`	no	1,2,3,...	`range`, `array`, `reference`	`once`
`newX`	no	knownX	`range`, `array`, `reference`	`once`
`const`	no	true	`scalar`, `reference`	`once`

Signature: regression-fit

Return shape: array.

Argument	Required	Default	Accepts	Repetition
`knownY`	yes	none	`range`, `array`, `reference`	`once`
`knownX`	no	1,2,3,...	`range`, `array`, `reference`	`once`
`const`	no	true	`scalar`, `reference`	`once`
`stats`	no	false	`scalar`, `reference`	`once`

Signature: probability-range

Return shape: scalar.

Argument	Required	Default	Accepts	Repetition
`xRange`	yes	none	`range`, `array`, `reference`	`once`
`probRange`	yes	none	`range`, `array`, `reference`	`once`
`lowerLimit`	no	0	`scalar`, `reference`	`once`
`upperLimit`	no	lowerLimit	`scalar`, `reference`	`once`

Semantic profiles

These values are normative for the listed Sheetwrite subset. function-defined and contextual are explicit limitations: consult the formula guides' function-specific sections rather than assuming another spreadsheet's edge behavior.

Semantics: aggregate

Dimension	Contract
shape	scalar: accepted range: accepted array: accepted broadcast: none result: scalar
coercion	blank: ignored text: ignored-in-ranges boolean: ignored-in-ranges error: propagate
text	case: not-applicable wildcard: not-applicable
environment	locale: invariant dateSystem: not-applicable
numeric	tolerance: binary64 domain: function-defined iteration: kind: none maximum: none
calculation	dependencies: tracked lazy: eager spill: scalar fill: relative-reference-rewrite copy: relative-reference-rewrite structuralRewrite: ast-reference-rewrite
persistence	snapshot: formula-source history: formula-source collaboration: formula-source xlsxSource: rewrite-on-structural-edit

Semantics: criteria

Dimension	Contract
shape	scalar: accepted range: accepted array: accepted broadcast: pairwise result: scalar
coercion	blank: function-defined text: function-defined boolean: function-defined error: propagate
text	case: insensitive wildcard: supported
environment	locale: invariant dateSystem: function-defined
numeric	tolerance: binary64 domain: function-defined iteration: kind: none maximum: none
calculation	dependencies: tracked lazy: eager spill: scalar fill: relative-reference-rewrite copy: relative-reference-rewrite structuralRewrite: ast-reference-rewrite
persistence	snapshot: formula-source history: formula-source collaboration: formula-source xlsxSource: rewrite-on-structural-edit

Semantics: analysis-distributions

Dimension	Contract
shape	scalar: accepted range: contextual array: contextual broadcast: none result: scalar
coercion	blank: zero text: number-if-parseable boolean: number error: propagate
text	case: not-applicable wildcard: not-applicable
environment	locale: invariant dateSystem: not-applicable
numeric	tolerance: binary64 domain: bounded iteration: kind: function-defined maximum: none
calculation	dependencies: tracked lazy: eager spill: scalar fill: relative-reference-rewrite copy: relative-reference-rewrite structuralRewrite: ast-reference-rewrite
persistence	snapshot: formula-source history: formula-source collaboration: formula-source xlsxSource: rewrite-on-structural-edit

Semantics: analysis-descriptive

Dimension	Contract
shape	scalar: accepted range: accepted array: accepted broadcast: none result: scalar
coercion	blank: ignored text: ignored-in-ranges boolean: ignored-in-ranges error: propagate
text	case: not-applicable wildcard: not-applicable
environment	locale: invariant dateSystem: not-applicable
numeric	tolerance: binary64 domain: function-defined iteration: kind: none maximum: none
calculation	dependencies: tracked lazy: eager spill: scalar fill: relative-reference-rewrite copy: relative-reference-rewrite structuralRewrite: ast-reference-rewrite
persistence	snapshot: formula-source history: formula-source collaboration: formula-source xlsxSource: rewrite-on-structural-edit

Semantics: analysis-regression

Dimension	Contract
shape	scalar: accepted range: accepted array: accepted broadcast: none result: contextual
coercion	blank: function-defined text: function-defined boolean: function-defined error: propagate
text	case: not-applicable wildcard: not-applicable
environment	locale: invariant dateSystem: not-applicable
numeric	tolerance: binary64 domain: function-defined iteration: kind: none maximum: none
calculation	dependencies: tracked lazy: eager spill: contextual fill: relative-reference-rewrite copy: relative-reference-rewrite structuralRewrite: ast-reference-rewrite
persistence	snapshot: formula-source history: formula-source collaboration: formula-source xlsxSource: rewrite-on-structural-edit

Dialect profiles

Dialect: excel-documented

Dialect	Status
Microsoft Excel	documented
Google Sheets	unverified
OpenFormula	unverified

Limitations: Google Sheets and OpenFormula results require producer evidence before compatibility is claimed.

Dialect: analysis-distributions

Dialect	Status
Microsoft Excel	documented
Google Sheets	unverified
OpenFormula	unverified

Limitations: Available only in the optional @sheetwrite/formulas analysis build; default @sheetwrite/wasm returns #NAME?. Scalar binary64 evaluation, not array broadcasting or blanket spreadsheet parity. Domain validation and finite numerical convergence may return #NUM!.

Dialect: analysis-descriptive

Dialect	Status
Microsoft Excel	documented
Google Sheets	unverified
OpenFormula	unverified

Limitations: Available only in the optional @sheetwrite/formulas analysis build; default @sheetwrite/wasm returns #NAME?. Regression functions skip pairs where either value is not a number. PERCENTRANK results are truncated, not rounded, to the requested significant digits.

Dialect: analysis-regression

Dialect	Status
Microsoft Excel	documented
Google Sheets	unverified
OpenFormula	unverified

Limitations: Available only in the optional @sheetwrite/formulas analysis build; default @sheetwrite/wasm returns #NAME?.

Implementation profiles

Implementation: implemented-assisted

Layer	Status and source/evidence
Parser	implemented `packages/wasm/src/calc.rs`
Evaluator	implemented `packages/wasm/src/eval/mod.rs` `packages/wasm/src/eval/functions.rs`
Formula assist	implemented `packages/core/src/formula-assist.ts`
Evidence	source-linked `packages/wasm/src/tests.rs` `packages/core/test/formula-assist.test.ts`

Implementation: analysis-distributions

Layer	Status and source/evidence
Parser	implemented `packages/wasm/src/calc.rs`
Evaluator	implemented `packages/wasm/src/eval/analysis/distributions.rs`
Formula assist	implemented `packages/core/src/formula-assist.ts`
Evidence	source-linked `scripts/formula-contract.test.ts`

Implementation: analysis-descriptive

Layer	Status and source/evidence
Parser	implemented `packages/wasm/src/calc.rs`
Evaluator	implemented `packages/wasm/src/eval/analysis/descriptive.rs`
Formula assist	implemented `packages/core/src/formula-assist.ts`
Evidence	source-linked `scripts/formula-contract.test.ts`

Implementation: analysis-regression

Layer	Status and source/evidence
Parser	implemented `packages/wasm/src/calc.rs`
Evaluator	implemented `packages/wasm/src/eval/analysis/regression.rs`
Formula assist	implemented `packages/core/src/formula-assist.ts`
Evidence	source-linked `packages/wasm/src/eval/analysis/regression.rs` `scripts/formula-contract.test.ts`

Loading documentation…