What is the formula used for function "CENTILE( )"?
J JE McGimpsey Jul 17, 2006 #2 Here's an explanation for QUARTILE. I believe the PERCENTILE() (the function in English versions) uses a similar algorithm: http://support.microsoft.com/kb/214072/en-us
Here's an explanation for QUARTILE. I believe the PERCENTILE() (the function in English versions) uses a similar algorithm: http://support.microsoft.com/kb/214072/en-us