PERCENTRANK function algorithm

  • Thread starter Thread starter NSERC_Rep
  • Start date Start date
N

NSERC_Rep

Is anybody familiar with the algorithm that drives the
PERCENTRANK function in Excel. If so I am looking for the
formula and the proof behind it.

Thanks!
 
NSERC_Rep -
Is anybody familiar with the algorithm that drives the PERCENTRANK
Click to expand...
function in Excel. If so I am looking for the formula and the proof behind
it. <

PERCENTRANK is probably similar to the PERCENTILE function, except
PERCENTRANK is likely based on integer rank numbers instead of actual
numerical values. As I recall, PERCENTILE assigns zero to the lowest value,
one to the highest value, and steps of 1/(n-1) for intermediate values with
linear interpolation.

- Mike Middleton, www.usfca.edu/~middleton
 
If you were looking for something with some theory and documentation
most introductory statistics books go through rank percentiles. These
are however, not the same as the percentrank used by excel. Sample
rank percentiles can be found using:
PR = [ ( P(<x) + 1/2*P(=x) ) / N ] * 100
See http://www.psychstat.smsu.edu/introbook2/images/trans8.gif

Rank percentiles can also be calculated from the normal curve. In
excel this can be accomplished using the NORMDIST function. ie:

=NORMDIST(A1,AVERAGE($A$1:$A$100),STDEV($A$1:$A$100),TRUE)

Which returns the probability of a particular score being at or below the
score A1 (or the area under the normal curve to the left of the given value)

More reading
http://www.psychstat.smsu.edu/introbook2/sbk12.xml#i.12.2.2.1

PS... I can't believe i'm helping an NSERC rep...

Dan E
 
-----Original Message-----
...
241C2.1766553%40bgtnsc04-news.ops.worldnet.att.net

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.
. Great! Thanks so much.
Click to expand...
 
Thanks very much! Your link was most helpfull.
-----Original Message-----
...
241C2.1766553%40bgtnsc04-news.ops.worldnet.att.net

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.
.
Click to expand...
 
Thanks for your reply.
-----Original Message-----
NSERC_Rep -
PERCENTRANK
function in Excel. If so I am looking for the formula and the proof behind
it. <

PERCENTRANK is probably similar to the PERCENTILE function, except
PERCENTRANK is likely based on integer rank numbers instead of actual
numerical values. As I recall, PERCENTILE assigns zero to the lowest value,
one to the highest value, and steps of 1/(n-1) for intermediate values with
linear interpolation.

- Mike Middleton, www.usfca.edu/~middleton


.
Click to expand...
 
Back
Top