# Median

(Difference between revisions)
 Revision as of 18:45, 30 April 2020 (view source)Martin (Talk | contribs)← Older edit Current revision as of 09:31, 24 June 2020 (view source)Jip (Talk | contribs) Line 5: Line 5: == '''syntax''' == == '''syntax''' == - * use the [[rth_element]] function with r = 0.5 to get the median of a set of [[attribute]] values + * use the [[rth_element]] function with r = 0.5 to get the median of a set of [[attribute]] values. '''Note: there is no function called median in GeoDMS.''' * Median(''a'', ''b'', ''c)'' is rewritten such that the middle value of ''a'', ''b'', and ''c'' is derived for each element. This can be used to bind a to a given range of allowed values. * Median(''a'', ''b'', ''c)'' is rewritten such that the middle value of ''a'', ''b'', and ''c'' is derived for each element. This can be used to bind a to a given range of allowed values.

## Current revision as of 09:31, 24 June 2020

Aggregation functions median

## definition

The median of a set of numeric values is the value separating the higher half of an attribute from the lower half.

## syntax

• use the rth_element function with r = 0.5 to get the median of a set of attribute values. Note: there is no function called median in GeoDMS.
• Median(a, b, c) is rewritten such that the middle value of a, b, and c is derived for each element. This can be used to bind a to a given range of allowed values.

## conditions median(a, b, c)

1. the domain of arguments a, b, and c must match or be void.
2. the values unit of arguments a, b, and c must match.
3. b is known to be not larger than c.