Statistical OperatorsElzed provides a few built-in statistical operators. Operators which work on a list of parameters (like average, perm, etc.) will also work on a single array.
average value
average( item_1, item_2,..., item_n )
average( array )
also
amean( item_1, item_2,..., item_n )
amean( array )
Returns the arithmetic mean of the list items. For example, average( 1, 3, 7 ) would return 3.67.
combinations
comb( size of population, group size )
Returns the number of combinations of groups of the given size formed from the given population size. Group size may not exceed population size. For example, comb( 10, 5 ) would return 252.
geometric mean
gmean( item_1, item_2,..., item_n )
gmean( array )
Returns the geometric mean of the list items. For example, gmean( 1, 3, 7 ) would return 2.76.
harmonic mean
hmean( item_1, item_2,..., item_n )
hmean( array )
Returns the harmonic mean of the list items. For example, hmean( 1, 3, 7 ) would return 2.03.
maximum value
max( item_1, item_2,..., item_n )
max( array )
Returns the largest item in the list. For example, max( 3, 42, 9, 17 ) would return 42.
minimum value
min( item_1, item_2,..., item_n )
min( array )
Returns the smallest item in the list. For example, min( 3, 42, 9, 17 ) would return 3.
permutations
perm( size of population, group size )
Returns the number of permutations of groups of the given size formed from the given population size. Group size may not exceed population size. For example, perm( 10, 5 ) would return 30240.
range
range( item_1, item_2,..., item_n )
range( array )
Returns the difference between the smallest and largest numbers in the passed-in list.
root mean square
rms( item_1, item_2,..., item_n )
rms( array )
Returns the root mean square of the list items. For example, rms( 1, 3, 7 ) would return 4.43.
standard deviation
stddev( item_1, item_2,..., item_n )
stddev( array )
Returns the standard deviation of the items in the list.
statistical variance
variance( item_1, item_2,..., item_n )
variance( array )
Returns the statistical variance of the passed-in list.
sum
sum( item_1, item_2,..., item_n )
sum( array )
Returns the arithmetic sum of the items in the list.
|