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 |