Calculation of a '95th percentile'

Calculation of a '95th percentile'

--------------------------------------------------------------------------------

Hi everyone,

For our needs, we have to integrate on a Report MYSQL, a calculation of a '95th percentile' average for a counter (in place of a 'normal' average).

In another words, we have to automatically substract the 5th 'highest values' of the total of the value, and so only make the average on the remaining 95th of the value.

And this treatment should appear as a function, that we could integrate on the Report.

Does this function already exist ?

Does anyone have any idea to help me to find how to do ?

Tks a lot to everybody.

Edited 1 time(s). Last edit at 07/31/2010 10:25AM by angel rivero.