Formualizer Docs
ReferenceFunctionsStatistics Functions

STDEV.P

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

Summary

Use STDEV.P when your values represent the entire population, not a sample.

Remarks

  • Requires at least one numeric value.
  • Returns #DIV/0! when no numeric values are provided.
  • Non-numeric values in referenced ranges are ignored.

Examples

Population standard deviation from scalar arguments
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1.632993161855452
Population standard deviation from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
0.816496580927726

FAQ

When does STDEV.P return #DIV/0!?

It returns #DIV/0! when no numeric values are provided.

Runtime metadata

Category

Statistics

Signature

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

STANDARDIZE

STANDARDIZE: Returns the z-score of `x` relative to a mean and standard deviation.

STDEV.S

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does STDEV.P return #DIV/0!?Runtime metadata