4D v19

VAR.P

Home

4D View Pro Handbuch
- Formeln in 4D View Pro
- - Operatoren und Werte
  - Zellenreferenzen
  - Formeln vom Plug-In 4D View konvertieren
  - ABS
  - ACOS
  - AND
  - ASIN
  - ATAN
  - AVERAGE
  - COLUMNLETTER
  - COS
  - COUNTA
  - EXP
  - FALSE
  - FINDCELL
  - FV
  - IF
  - INDIRECT
  - ISBLANK
  - LEN
  - LN
  - LOOKUP
  - MAX
  - MID
  - MIN
  - NOT
  - NOW
  - NPER
  - OR
  - PI
  - PMT
  - PV
  - RAND
  - RATE
  - ROUND
  - ROW
  - RUNTIME_CURRENT_TIME
  - RUNTIME_DATE
  - RUNTIME_STRING
  - RUNTIME_TIME
  - RUNTIME_VIEW_STRING
  - SIN
  - SQRT
  - STDEV.P
  - SUBSTITUTE
  - SUM
  - TAN
  - TEXT
  - TODAY
  - TRUE
  - TYPE
  - VAR.P

Home

4D v19

4D View Pro Handbuch

Formeln in 4D View Pro

VAR.P


VAR.P ( value {, value2 , ... , valueN} )

Parameter	Typ	Beschreibung
value	Zahl, Array	Values to get the variance

Beschreibung

The VAR.P function returns the variance based on the entire population, which uses numeric values.

In value, pass the values to evaluate. Each argument can be a number, or an array of numbers (a single array (cell range) or multiple arrays (cell ranges)).

Note: This function assumes that its arguments are the entire population. If your data represents only a sample of the population, then compute the variance using the VAR.S function.