Thanks. So if Excel gives me a percent rank of 43% for one of the data
points (where there are multiple equal values in the set), how do I describe
the significance of this in an analysis report to my boss. What I had been
looking for is a way to say x value is greater than or equal to x% of values
in the list. Is there a different function I should use?

Beth Cote

"Michael R Middleton" wrote:

emcote -

Please explain the definition of this function in a data set. When I
perform the same function on the data in Quatro Pro or by hand, I get
different anwer! <

Different authors, and perhaps different spreadsheets, use different methods
for finding percentiles and ranks, particularly the treatment of endpoint
values and the treatment of ties.

See the Knowledge Base article "PERCENTRANK() May Appear to Return Incorrect
Results" at

http://support.microsoft.com/default...b;en-us;129436

- Mike

www.mikemiddleton.com