stddev() function
The stddev()
function computes the standard deviation of non-null records in a specified column.
stddev()
is an aggregate function.
Output data type: Float
stddev(column: "_value", mode: "sample")
Parameters
column
Column to operate on.
Default is "_value"
.
mode
Standard deviation mode or type of standard deviation to calculate.
Defaults to "sample"
.
The available options are:
sample
Calculates the sample standard deviation where the data is considered to be part of a larger population.
population
Calculates the population standard deviation where the data is considered a population of its own.
tables
Input data.
Default is piped-forward data (<-
).
Examples
The following example uses data provided by the sampledata
package
to show how stddev()
transforms data.
import "sampledata"
sampledata.int()
|> stddev()
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, the following resources are available:
InfluxDB Cloud customers can contact InfluxData Support.