PERCENTILE.EXCE VERSUS PERCENTIL.INC

What is the difference between the formula which uses PERCENTILE.EXC versus PERCENTILE.INC?  I understand what they are, but I do not understand their significance.  How would a user choose between them?  Why?

 

Douglas Eckert

York PA

 

Question Info


Last updated October 17, 2019 Views 70,927 Applies to:
Answer
Answer

The syntax is PERCENTILE.EXC(array, k) and PERCENTILE.INC(array, k)

 

PERCENTILE.EXC only works if k is between 1/n and 1-1/n, where n is the number of elements in array.

 

PERCENTILE.INC uses a slightly less accurate algorithm, but it works for any value of k between 0 and 1.

---
Kind regards, HansV
www.eileenslounge.com

20 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.