Support > Repository > Function > Statistical processing
ja | en

We introduce six statistical processing functions. Applicable to repetitive items, repeating containers, foreign key child models, etc.

MEDIAN |  MODE |  STDEV |  STDEVP |  VAR |  VARP

MEDIAN (array of numbers)

MEDIAN (Repeat item of numeric type)

MEDIAN (repeat container item of numerical type)

MEDIAN (Numeric type foreign key child model item)

Find the median.The return value is "8 byte floating point type".

MEDIAN(ARRAY_INT(80,55,90,55,77,64))

The above expression returns "70.5".

MODE (array of numbers)

MODE (Repeat item of numeric type)

MODE (repeating container item of numeric type)

MODE (numeric type foreign key child model item)

Find the mode value.The type of the return value is the number type passed to the argument.
If none of them is the mode value (all numbers are one), null is returned.

MODE(ARRAY_INT(80,55,90,55,77,64))

The above expression returns "55".

STDEV (array of numbers)

STDEV (Repeat item of numeric type)

STDEV (Numeric type repeating container item)

STDEV (Numeric type foreign key child model item)

Find the standard deviation.The return value is "8 byte floating point type".
Two or more values ​​are required for the number of arguments.Below this value, the value is undefined (Double.NaN).

STDEV(ARRAY_DOUBLE(5.0, 6.0, 7.0, 8.0))

The above expression returns "1.2909944487358056".

STDEVP (array of numbers)

STDEVP (Repeat item of numeric type)

STDEVP (Numeric Repeat Container Item)

STDEVP (Numeric foreign key child model item)

Find the standard deviation of the population.The return value is "8 byte floating point type".
Two or more values ​​are required for the number of arguments.Below this value, the value is undefined (Double.NaN).

STDEVP(ARRAY_DOUBLE(5.0, 6.0, 7.0, 8.0))

The above expression returns "1.118033988749895".

VAR (array of numbers)

VAR (Repeat item of numeric type)

VAR (repeating container item of numeric type)

VAR (numeric type foreign key child model item)

Calculate the variance.The return value is "8 byte floating point type".
Two or more values ​​are required for the number of arguments.Below this value, the value is undefined (Double.NaN).

VAR(ARRAY_DOUBLE(5.0, 6.0, 7.0, 8.0))

The above expression returns "1.6666666666666667".

VARP (array of numbers)

VARP (Repeat item of numeric type)

VARP (repeating container item of numeric type)

VARP (numeric foreign key child model item)

Calculate the variance value of the population.The return value is "8 byte floating point type".
Two or more values ​​are required for the number of arguments.Below this value, the value is undefined (Double.NaN).

VARP(ARRAY_DOUBLE(5.0, 6.0, 7.0, 8.0))

The above expression returns "1.25".