MySQL Forums :: Newbie :: Calculation of a '95th percentile'


Advanced Search

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


Subject Written By Posted
Calculation of a '95th percentile' angel rivero 07/31/2010 10:24AM
Re: Calculation of a '95th percentile' laptop alias 07/31/2010 10:47AM
Re: Calculation of a '95th percentile' angel rivero 07/31/2010 12:05PM
Re: Calculation of a '95th percentile' laptop alias 07/31/2010 01:36PM
Re: Calculation of a '95th percentile' angel rivero 07/31/2010 03:12PM
Re: Calculation of a '95th percentile' laptop alias 08/02/2010 10:47AM
Re: Calculation of a '95th percentile' angel rivero 08/02/2010 11:00AM
Re: Calculation of a '95th percentile' laptop alias 08/02/2010 11:37AM
Re: Calculation of a '95th percentile' angel rivero 08/02/2010 12:37PM
Re: Calculation of a '95th percentile' laptop alias 08/03/2010 05:43AM
Re: Calculation of a '95th percentile' angel rivero 08/03/2010 12:06PM
Re: Calculation of a '95th percentile' Rick James 08/03/2010 08:34PM
Re: Calculation of a '95th percentile' angel rivero 08/04/2010 01:33AM
Re: Calculation of a '95th percentile' Rick James 08/04/2010 09:02AM
Re: Calculation of a '95th percentile' angel rivero 08/04/2010 10:14AM
Re: Calculation of a '95th percentile' angel rivero 08/04/2010 12:33PM
Re: Calculation of a '95th percentile' angel rivero 08/03/2010 03:12AM
Re: Calculation of a '95th percentile' laptop alias 08/03/2010 03:51AM
Re: Calculation of a '95th percentile' angel rivero 08/03/2010 04:01AM
Re: Calculation of a '95th percentile' Rick James 07/31/2010 04:19PM
Re: Calculation of a '95th percentile' angel rivero 08/01/2010 12:06PM
Re: Calculation of a '95th percentile' Rick James 08/01/2010 12:57PM
Re: Calculation of a '95th percentile' angel rivero 08/01/2010 05:50PM
Re: Calculation of a '95th percentile' Rick James 08/01/2010 09:35PM
Re: Calculation of a '95th percentile' angel rivero 08/02/2010 02:22AM
Re: Calculation of a '95th percentile' Rick James 08/02/2010 07:57AM
Re: Calculation of a '95th percentile' angel rivero 08/02/2010 08:55AM


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.