CAS 6


median
- Summary

Summary

The middle value when the number of records is odd; the mean of the two middle values when the number of records is even.

Examples

median APPVAL
median APPVAL (STATE in 'VA')
median 31 36 53 53 67
median 2 3 1 5
median (2 3 1 5)(1 0 1 1)

Syntax

median NumField (Weight|SelectionStatement)

Right Arguments

Name Data Type Input Type Description Optional Default
NumField Numeric Field No
SelectionStatement Boolean Field, Constant Yes
Weight Numeric Field Yes

Result

Type: Numeric

Median or middle value



Build 6.0.624