Bug #71391 Need Mean Absolute Deviation, a new aggregate function

Submitted: 15 Jan 2014 18:05 Modified: 16 Jan 2014 18:33
Reporter: Oliver Jones Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:all OS:Any
Assigned to: CPU Architecture:Any
Tags: aggregate

[15 Jan 2014 18:05] Oliver Jones 
Description:
It would be helpful to have a new aggregate function, Mean Absolute Deviation, implemented in MySQL.  

This is defined as  AVG(ABS((value) - AVG(value)))

Computing it is unfortunately a two-pass operation.

The statistical and scientific case for making this function available is made here:

http://www.edge.org/response-detail/25401

How to repeat:
As this is a feature request, I don't have any how-to-repeat instructions.
[16 Jan 2014 18:33] MySQL Verification Team 
This is a justified request for a feature that is rarely used.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.