Median

Find the median of a column or group.

Usage

Median(numbers)

numbers (required) The column of numbers to be evaluated.

NOTE: If there is an even number of values, Median will interpolate between the middle values.

Example

Median([Temperature])

• Find the median temperature value. If the column values were 3, 5, 7 and 20 the result would be 6.

See Also

• Avg
• Percentilecont
• Percentiledisc