Home › Functions › Statistical › VAR.P
fx
VAR.P
Statistical  ·  Since: Excel 2003  ·  9 languages

Calculates variance based on the entire population (ignores logical values and text in the population).

🌐 Translations

English VAR.P
Deutsch VAR.P
Français VAR.P.N
Español VAR.P
Italiano VAR.P
Português VAR.P
Nederlands VAR.P
Polski WARIANCJA.POP
Русский ДИСП.Г

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

VAR.P(number1,[number2],...)

Arguments

number1 (required) — The first number argument corresponding to a population.
number2 (optional) — Number arguments 2 to 254 corresponding to a population.

▶ Examples

=VAR.P(A2:A11)

Related functions

Copied to clipboard