MySQL Bugs: #71391: Need Mean Absolute Deviation, a new aggregate function

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

This is a justified request for a feature that is rarely used.