2.11 Statistics

2.11 Statistics

These functions take a list of inputs separated by commas and will return the result of the function across all the inputs at each point in time:

function(a,b,..,n)

The order of the inputs is not important

2.11.1 MAX: Maximum

The minimum of all the inputs at each point in time. The syntax for a MAX function is:

MAX(8,7,4) = 8

2.11.2 MIN: Minimum

The minimum of all the inputs at each point in time. The syntax for a MIN function is:

MIN(8,7,4) = 4

2.11.3 MEAN: Mean

The mean of all the inputs at each point in time. The syntax for a MEAN function is:

MEAN(8,7,4) = 6.33

2.11.4 MEDIAN: Median

The median of all the inputs at each point in time. The syntax for a MEDIAN function is:

MEDIAN(8,7,4) = 7

2.11.5 STDDEV: Standard Deviation

The standard deviate of all the inputs at each point in time. The syntax for a STDDEV function is:

STDDEV(8,6,4) = 2

2.11.6 VARIANCE: Variance

The standard deviate of all the inputs at each point in time. The syntax for a VARIANCE function is:

VARIANCE(8,6,4) = 4