4D v18

VAR.P

Home

4D View Pro Reference
- 4D View Pro Formulas
- - Operators and values
  - Cell references
  - Converting 4D View plug-in formulas
  - 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 v18

4D View Pro Reference

4D View Pro Formulas

VAR.P


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

Parameter	Type	Description
value	Number, Array	Values to get the variance

Description

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.

Example

VAR.P(B3,C4,B2,D10,E5)
  VAR.P(A1:A9)

VAR.P(98,85,76,87,92,89,90) //39.265306122449