Statistical Functions

MIN(a, b, ...)

Returns the smallest argument. Requires at least one argument.

Example: MIN(Demand, Capacity)

MAX(a, b, ...)

Returns the largest argument. Requires at least one argument.

Example: MAX(Inventory, 0)

MEAN(a, b, ...)

Returns the arithmetic mean. Requires at least one argument.

Aliases: AVG, AVERAGE.

Example: MEAN(Q1, Q2, Q3, Q4)

SUM(a, b, ...)

Returns the sum of all arguments. Requires at least one argument.

When its single argument is a model array, equation normalization supplies the array aggregate rather than a scalar element.

Example: SUM(Fixed_Cost, Variable_Cost)

STDEV(a, b, ...)

Returns the population standard deviation: squared deviations are divided by the number of arguments, not by n - 1. Requires at least one argument.

Aliases: STDDEV, STANDARDDEVIATION, STANDARD_DEVIATION.

Example: STDEV(8, 10, 12) returns approximately 1.633.