PERCENTILE.EXC

The Excel PERCENTILE.EXC function calculates the "kth percentile" for a set of data. The kth percentile is a value below which k percent of values in the data set fall. A percentile calculated with .4 as k means 40% percent of values are less than or equal to the calculated result, a percentile calculated with k = .9 means 90% percent of values are less than or equal to the calculated result. To use PERCENTILE.EXC, provide a range of values and a number between 0 and 1 for the "k" argument, which represents percent. For example: You can also specify k as a percent using the % character: In the example shown, the formula in G5 is: where "scores" is the named range C5:C14.