ReferenceFunctionsStatistics Functions

VAR.S

VAR.S: Estimates sample variance using `n-1` in the denominator.

Summary

VAR.S is the squared counterpart of STDEV.S for sample-based variability.

Remarks

Requires at least two numeric values.
Returns #DIV/0! when fewer than two numeric values are provided.
Non-numeric values in referenced ranges are ignored.

Examples

Sample variance from scalar arguments

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

4

Sample variance from a range

Grid

Cell	Value

Formula

=

Result

Not evaluated yet.

Expected

1

FAQ

Why does VAR.S return #DIV/0!?

Sample variance requires at least two numeric observations.

Runtime metadata

Category

Statistics

Signature

VAR.S(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

PUREREDUCTIONNUMERIC_ONLYSTREAM_OK

Source

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

VAR.P

VAR.P: Returns population variance using `n` in the denominator.

WEIBULL.DIST

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

On this page

Summary Remarks Examples Related functions FAQ Why does VAR.S return #DIV/0!?Runtime metadata