percentiles?

[Guest]

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.

 

[JE McGimpsey]

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

http://support.microsoft.com/default.aspx?scid=kb;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