I am looking for a formula to work in Excel 2002/2003 that will give correct
quartile for performance info. where you can have high or low values which
are 'good' performance. The standard formulae do not work for both examples.
Also what if values are 0?

"Francisco" wrote:

I have a suggestion that we will be very useful for our company.
The way Excel calculate PERCENTILE and QUARTILE series is not appropiate for
discrete numbers.

My suggestion
At the moment =percentile(a1:a10,.05) gives 5.5 in the sequence
{1,2,3,4,5,6,7,8,9,10}. This is incorrect on discrete numbers.

Following the example above, I want to gather discrete numbers, i.e. "5" on
the series rather than "5.5". The same apply for QUARTILE formulas where a
second parameter is needed.
Add a Third parameter [optional] as follows:
- 0, default (as it currently works)
- 1, takes the inferior discrete number
- 2, takes the superior discrete number


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc