STDEVP

Syntax

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, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Trino, Yandex Documents, YDB.

Previous
STDEV
Next
SUM