10.5.10 Lists

Functions which operate on lists of values.

Some of these resemble similar functions in the Arrays class, and in some cases are interchangeable, but these are easier to use on non-array values because you don't have to explicitly wrap up lists of arguments as an array. However, for implementation reasons, most of the functions defined here can be used on values which are already double[] arrays (for instance array-valued columns) rather than as comma-separated lists of floating point values.

sum( values, ... )

Returns the sum of all the non-blank supplied arguments.

• values (floating point, one or more): one or more numeric values
• return value (floating point): sum of values

mean( values, ... )

Returns the mean of all the non-blank supplied arguments.

• values (floating point, one or more): one or more numeric values
• return value (floating point): mean of values

variance( values, ... )

Returns the population variance of the non-blank supplied arguments.

• values (floating point, one or more): one or more numeric values
• return value (floating point): population variance of values

stdev( values, ... )

Returns the population standard deviation of the non-blank supplied arguments.

• values (floating point, one or more): one or more numeric values
• return value (floating point): population standard deviation of values

min( values, ... )

Returns the minimum of all the non-blank supplied arguments.

• values (floating point, one or more): one or more numeric values
• return value (floating point): minimum of values

max( values, ... )

Returns the maximum of all the non-blank supplied arguments.

• values (floating point, one or more): one or more numeric values
• return value (floating point): maximum of values

median( values, ... )

Returns the median of all the non-blank supplied arguments.

• values (floating point, one or more): one or more numeric values
• return value (floating point): median of values

countTrue( values, ... )

Returns the number of true values in a list of boolean arguments. Note if any of the values are blank, the result may be blank as well.

• values (boolean, one or more): one or more true/false values
• return value (integer): number of elements of values that are true