Formualizer Docs
ReferenceFunctionsStatistics Functions

VAR.P

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

Summary

VAR.P describes dispersion for a complete population of numeric values.

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 variance from scalar arguments
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2.6666666666666665
Population variance from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
0.6666666666666666

FAQ

What is the denominator difference vs VAR.S?

VAR.P divides by n, while VAR.S divides by n-1.

Runtime metadata

Category

Statistics

Signature

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

TRIMMEAN

TRIMMEAN: Returns the mean after trimming a percentage of values from both tails.

VAR.S

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhat is the denominator difference vs VAR.S?Runtime metadata