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

PERCENTILE

Returns the value at a given percentile of a dataset.

Sample Usage

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

Syntax

PERCENTILE(range, percentile)

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

Examples

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

 

Notes

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