Returns the median absolute deviation from the median.
Category: | Descriptive Statistics |
Returned data type: | DOUBLE |
specifies any valid expression that evaluates to a numeric value of which the median absolute deviation from the median is to be computed.
Data type | DOUBLE |
Statements
|
Results
|
---|---|
select mad(2, 4, 1, 3, 5, 999999); |
1.5 |