elasticsearch/docs/reference/query-languages/esql/_snippets/functions/examples/std_dev.md

% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.

Examples

FROM employees
| STATS std_dev_height = STD_DEV(height)

std_dev_height:double
0.2063704436

The expression can use inline functions. For example, to calculate the population standard deviation of each employee’s maximum salary changes, first use MV_MAX on each row, and then use STD_DEV on the result

FROM employees
| STATS stddev_salary_change = STD_DEV(MV_MAX(salary_change))

stddev_salary_change:double
6.8758295929