MEDIAN
The following section describes the syntax and usage of the MEDIAN function in ActivityInfo.
Description
The MEDIAN function is used to find the median value from a set of values. The function returns the "middle" value from a set a values.
Syntax
MEDIAN(val1, val2, val3, ...)
Argument | Required | Description |
---|---|---|
val1 | Yes | A numeric value. |
val2 | Yes | Another numeric value. |
val3 | Yes | Another numeric value. |
... | No | Any further numeric values. If an argument is missing, NA, or non-numeric, it will be excluded from the calculation. |
Result
The median value from the set of input arguments.
- If there are an odd number of values, the function returns the value which separates the lower and higher halves of the input set.
- If there are an even number of values, the function returns the average of the middle two values in the input set.

Example
We will be using the MEDIAN function to calculate the middle row value from a set of three columns.
Arguments
We will be using three Quantity fields:
- "Value 1" (with code "val1")
- "Value 2" (with code "val2")
- "Value 3" (with code "val3")

Formula
MEDIAN(val1,val2,val3)
Results
