STDEV
The STDEV function returns the statistical standard deviation of all values in the specified expression.
Syntax :
STDEV(Expression,[Condition])| Parameters | Description |
|---|---|
| STDEV(Expression) | Statistical Standard deviation. |
| STDEV(Expression, value<>' ') | Statistical standard deviation 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
dSTDEV = STDEV(Price)
DEBUG(dSTDEV)Result :
dSTDEV
= 3.11Example 2
dSTDEV = STDEV(Price, ProductName <>'Bottle')
DEBUG(dSTDEV)Result :
dSTDEV
= 3.59