Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
Home
›
Functions
›
Compatibility
›
VARP
fx
VARP
Compatibility
· Since: Excel 2003 · 9 languages
Calculates variance based on the entire population.
🌐
Translations
English
VARP
Deutsch
VARIANZEN
Français
VAR.P
Español
VARP
Italiano
VAR.POP
Português
VARP
Nederlands
VARP
Polski
WARIANCJA.POPUL
Русский
ДИСПР
📦
Availability
Excel version
Available
Excel 2007
✓
Excel 2013
✓
Excel 2019
✓
Excel 2021
✓
Microsoft 365
✓
Translate a formula with this function
fx
EN
=VARP(A2:A11)
fx
DE
⌨
Syntax
VARP(number1,[number2],...)
Arguments
number1
(required)
— The first number argument corresponding to a population.
number2
(optional)
— Number arguments 2 to 255 corresponding to a population.
▶
Examples
=VARP(A2:A11)
Related functions
BETADIST
BETAINV
BINOMDIST
CEILING
CHIDIST
CHIINV
CHITEST
CONFIDENCE
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›