How does excel calculates the percentiles worksheet function? The results
returned from excel differ from the results obtained with the generally used
formula - R = k*(n+1) with linear interpolation between the values located
between the two nearest integer R values.

AFAICT it's the same function as for quartiles - see

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

Instead of the

quart/4

substitute

percentile/100

And see this discussion by "Dr. Math":

http://mathforum.org/library/drmath/view/60969.html


In article ,
"Agnes Goris" <Agnes wrote:

How does excel calculates the percentiles worksheet function? The results
returned from excel differ from the results obtained with the generally used
formula - R = k*(n+1) with linear interpolation between the values located
between the two nearest integer R values.