STDEVP
Syntax
Standard
Extended
STDEVP( value )
STDEVP( value
[ FIXED ... | INCLUDE ... | EXCLUDE ... ]
[ BEFORE FILTER BY ... ]
)
More info:
Description
Returns the statistical standard deviation of all values in the expression based on the biased population. The function shows how far data points are from their average. In other words, standard deviation shows to what extent values in a dataset deviate from their average.
Argument types:
value—Fractional number | Integer
Return type: Fractional number
Example
Source data
| Date | Temperature |
|---|---|
2019-03-01 |
5.00 |
2019-03-02 |
0.00 |
2019-03-03 |
-3.00 |
2019-03-04 |
1.00 |
2019-03-05 |
4.00 |
2019-03-06 |
5.00 |
2019-03-07 |
1.00 |
2019-03-08 |
-6.00 |
2019-03-09 |
-6.00 |
2019-03-10 |
-4.00 |
2019-03-11 |
-2.00 |
2019-03-12 |
0.00 |
Formulas:
- Temperature SD:
STDEVP([Temperature]).
Result
| Temperature SD |
|---|
3.73 |
Data source support
ClickHouse 21.8, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, YDB.