MySQL Forums
Forum List  »  Newbie

Calculation of a '95th percentile'
Posted by: angel rivero
Date: July 31, 2010 10:24AM

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.

Options: ReplyQuote

Written By
Calculation of a '95th percentile'
July 31, 2010 10:24AM

Sorry, you can't reply to this topic. It has been closed.

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.