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

PERCENTILEEXC

Returns the value at a given percentile of a dataset.

Sample Usage

PERCENTILEEXC(A2:A6,0.5)
PERCENTILEEXC(A2:B6,A7) 

Syntax

PERCENTILEEXC(range, percentile)

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

Examples

 

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

 

Notes

  • The value returned by PERCENTILEEXC 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.