Aggregates

Subtopics

The built-in math module contains a few aggregate functions useful for calculating statistics. One example, mean, is for calculating the arithmetic mean of a set. Since this function belongs to the math module, the module name needs to be specified when calling it:

Input

Run

select math::mean({1, 3, 5});

select math::mean({1, 3, 5});

Output Objects

Press the 'Run' button to evaluate the input

Two others, stddev and stddev_pop, are for calculating the sample and population standard deviation, respectively. Similarly, var and var_pop allow for calculating sample and population variance. Try them out:

Input

Run

select math::stddev({1, 3, 5});

select math::stddev({1, 3, 5});

Output Objects

Press the 'Run' button to evaluate the input

Input

Run

select math::var({1, 3, 5});

select math::var({1, 3, 5});

Output Objects

Press the 'Run' button to evaluate the input

Prev NextShapes