Median [Med]

Return to Complete List of Functions

The Median function determines the median value of a data series within a given period. Parameters ------------------ Data          The data to evaluate. This is typically a field in a data series or a calculated value. Period        The number of bars of data to include in the sample, including the current value.                   For example, a period of 3 includes the current value and the two previous values. Note: An end point to the Period parameter can be simulated using the Lag function to obtain a previous value of this function. See the notes for the Lag function for more information. Function Value ------------------------ This function determines the median value of a data series within a given period. The median is the number in the middle of all of the values if the values were to be sorted. If an odd value is used for the period, the median will be an actual number from the series. If an even value is used, the median will be the average of the two middle values. If the data series does not have enough data to fill the period or it contains a null during the period, a null is returned. As a result of finding the median, half of the values during the given period have a value equal to or greater than the median and half of the values have a value equal to or less than the median. The median is useful for obtaining an "average" value of a data series while practically removing the effects of outliers. Data    Median(Data,3)   Median(Data,4) ----------------------------------------------------------------   0   1   2                 1   4                 2                         1.5   8                 4                         3   7                 7                         5.5   6                 7                         6.5