Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

PERCENTILE.EXC

Returns the value at a given percentile of a dataset.

Sample Usage

PERCENTILE.EXC(A2:A6,0.5)
PERCENTILE.EXC(A2:B6,A7) 

Syntax

PERCENTILE.EXC(range, percentile)

  • range - The range containing the dataset.
  • percentile - The percentile value in the range 0..1, exclusive.

Examples

PERCENTILE.EXC(A2:A6,0.5) returns the 50th percentile of the dataset.

 

Notes

  • The value returned by PERCENTILE.EXC is not necessarily a member of range.
  • The 50th percentile, i.e. setting percentile to 0.5 is equivalent to using MEDIAN with the same dataset.