Formualizer Docs
ReferenceFunctionsStatistics Functions

STDEV.S

STDEV.S: Estimates sample standard deviation using `n-1` in the denominator.

Summary

STDEV.S measures spread when your values represent a sample of a larger population.

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 standard deviation from scalar arguments
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2
Sample standard deviation from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
2

FAQ

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

Sample standard deviation needs at least two numeric values.

Runtime metadata

Category

Statistics

Signature

STDEV.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

STDEV.P

STDEV.P: Returns population standard deviation using `n` in the denominator.

STEYX

STEYX: Returns the standard error of y-estimates from a simple linear regression.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does STDEV.S return #DIV/0!?Runtime metadata