MEDIAN function

This topic describes the formula syntax and usage of the MEDIAN function in the Data Quality Execute Formula transform.

Description

Returns the median of the given numbers. This function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution.

Syntax

MEDIAN(number1, [number2], ...)

The MEDIAN function has the following arguments

  • number1 Required. The first number for the median.
  • number2,... Optional. Subsequent numbers for the median.

Notes

  • If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle. See the second formula in the example.
  • Arguments can be numbers, or ranges or column references that contain numbers.
  • Logical values and text representations of numbers in the list of arguments are counted.
  • If a range or column reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
  • Argument that cannot be translated into numbers cause errors.

Example

Table 1. Data
Column1 Column2 Column3 Column4 Column5 Column6
1 2 3 4 5 6
Formula Description Result
MEDIAN([Column1]:[Column5] There are five numbers in this range. The third number is the median 3
MEDIAN([Column1]:[Column6] There are six numbers in this range. The median is the midway point between the third and fourth numbers. 3.5