image-2

PERCENTILE vs PERCENTILE.INC vs PERCENTILE.EXC

PERCENTILE.EXC and PERCENTILE.INC differs only in the way the possibly-non-integer rank is calculated. For PERCENTILE.INC (and PERCENTILE) the calculated rank is K*(N-1)+1. For PERCENTILE.EXC the calculated rank is K*(N+1). Percentile Percentile is a statistics term used to describe the Nth observation in a data set after sorting in ascending order. For example, 40th percentile (P40) Read More