Median
Finds the median (middle value) of all numeric arguments.
Syntax
Median(value1, value2, ...)
Median(array)
Parameters
- values (number…): One or more numeric values, OR
- array (array): A single array of numeric values
Returns
- number: The median of all provided numeric values, or
nullif no numeric arguments are provided
Description
Calculates the median by sorting all numeric values and returning the middle value. For an odd count of numbers, returns the middle value. For an even count, returns the average of the two middle values.
Non-numeric arguments are ignored. Returns null if no numeric arguments are provided.
Examples
Odd count of values
var med = Median(1, 3, 5) # Returns 3
Even count of values
var med = Median(1, 3, 5, 7) # Returns 4 (average of 3 and 5)
Unsorted input
var med = Median(5, 1, 9, 3, 7) # Returns 5 (middle of sorted: 1,3,5,7,9)
Single value
var med = Median(42) # Returns 42
Statistical analysis
var salaries = [45000, 52000, 48000, 150000, 51000]
var avg = Average(salaries)
# Returns 69200 (skewed by outlier)
var med = Median(salaries)
# Returns 51000 (better represents typical salary)
Notes
- Returns
nullif no numeric arguments are provided - Non-numeric arguments are silently ignored
- Accepts a single array argument for convenience
- Median is less sensitive to outliers than average
- For calculating average (arithmetic mean), use
Average - For calculating mode (most frequent), use
Mode