4D v18
STDEV.P
- 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
STDEV.P
| STDEV.P ( value {, value2 , ... , valueN} ) | ||||||||
| Parameter | Type | Description | ||||||
| value | Number, CellRef |
|
Values to evaluate | |||||
The STDEV.P function returns the standard deviation for an entire population of numeric values. Standard deviation is a measure of the dispersion of values in relation to the average (average value).
In value, value2..., pass numeric arguments corresponding to the population. Each argument can be a cell, a cell range, or a number. This function can have up to 255 arguments.
Note: If your data represents a sample of the population, then compute the standard deviation using the STDEV function.
The STDEV.P is calculated using the "biased" or "n" method. The STDEV.P function uses the following formula:
STDEV.P(A1,B2,C3,D4,E5,F6)
STDEV.P(A1:A9)
STDEV.P(95,89,73,87,85,76,100,96,96) gives the result 8.8079649700473
Product: 4D
Theme: 4D View Pro Formulas
4D View Pro Reference ( 4D v18)
