STDEVP
The STDEVP function returns the statistical standard deviation for the population for all values in the specified expression.
Syntax :
STDEVP(Expression,[Condition])| Parameters | Description |
|---|---|
| STDEVP(Expression) | Statistical Standard deviation for the population. |
| STDEVP(Expression, "value<> ' ') | Statistical standard deviation for the population for values with certain conditions. |
Examples :
Table Name : Products
| ProductID | Product Name | Price |
|---|---|---|
| 1 | Pen | 6 |
| 2 | Pencil | 3 |
| 3 | Eraser | 2 |
| 4 | Bottle | 5 |
| 5 | Book | 10 |
Example 1
dSTDEVP = STDEVP(Price)
DEBUG(dSTDEVP)Result :
dSTDEVP
= 2.78Example 2
dSTDEVP = STDEVP(Price, ProductName <>'Bottle')
DEBUG(dSTDEVP)Result :
dSTDEVP
= 3.11