Statistical - PERCENTILE.EXC Function

Description

The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0...1, exclusive.

Syntax

PERCENTILE.EXC (array,k)

Arguments

Argument Description Required/ Optional
Array The array or range of data that defines relative standing. Required
K The percentile value in the range 0...1, exclusive. Required

Notes

  • If k is not a multiple of 1/(n - 1), PERCENTILE.EXC interpolates to determine the value at the k-th percentile.

  • PERCENTILE.EXC will interpolate when the value for the specified percentile lies between two values in the array. If it cannot interpolate for the percentile, k specified, Excel will return #NUM! error.

  • If array is empty, PERCENTILE.EXC returns the #NUM! error value.

  • If k is nonnumeric, PERCENTILE.EXC returns the #VALUE! error value.

  • If k is ≤ 0 or if k ≥ 1, PERCENTILE.EXC returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

Percentile.Exc Function
advanced_excel_statistical_functions.htm
Advertisements