• 462K Members
• 6,872 Online
• 559K Conversations

New Contributor

# Definition of PERCENTILE.EXC (in german QUANTIL.EXKL) and related function

Hello,

I think that the description of the PERCENTILE.EXC (QUANTIL.EXKL in german) is not right (at https://support.office.com/en-us/article/percentile-exc-function-bbaa7204-e9e1-4010-85bf-c31dc5dce4b...) (in german at https://support.office.com/de-de/article/QUANTIL-
EXKL-Funktion-bbaa7204-e9e1-4010-85bf-c31dc5dce4ba

In my opinion, PERCENTILE.EXC uses multiples of 1/(n+1) for the interpolation in contrast to PERCENTILE.INC, which uses multiples of 1/(n-1).

In the description of PERCENTILE.EXC (QUANTIL.EXKL), however, multiples of 1 / (n- 1) would lead to a false result, since there is a copy-paste error from .INC to .EXC?

In my calculated examples my hypothesis holds and the calculation for PERCENTILE.EXC would be for 0<p<1 the same as the definition in the Java Class Percentile (https:
math/stat/descriptive/rank/Percentile.html).

Moreover, the definitions of QUARTILE.INC (in german QUARTILE.INKL) (interpolation via multiples of 1/(n-1)) and QUARTILE.EXC (in german QUARTILE.EXKL) (interpolation via 1/(n+1)) corresponds and are special cases for p=0.25 and p=0.75 of PERCENTILE.INC and PERCENTILE.EXC.

My question is: Am I right?

If not so: What is the definition of all these mentioned functions?

Kind regards,

Tobias Wiernicki-Krips

3 Replies

# Re: Definition of PERCENTILE.EXC (in german QUANTIL.EXKL) and related function

I've forwarded your question to the people in the Excel team responsible for the technical documentation.

# Re: Definition of PERCENTILE.EXC (in german QUANTIL.EXKL) and related function

Thank you very much!

# Re: Definition of PERCENTILE.EXC (in german QUANTIL.EXKL) and related function

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies