Formualizer Docs
ReferenceFunctionsStatistics Functions

PERCENTILE.EXC

PERCENTILE.EXC: Returns the k-th percentile of a data set using exclusive interpolation.

Summary

PERCENTILE.EXC uses the n+1 rank basis and excludes the exact endpoints 0 and 1.

Remarks

  • k must satisfy 0 < k < 1.
  • Returns #NUM! when the percentile falls outside the valid rank range for the data size.
  • Returns #NUM! for empty numeric input.

Examples

Exclusive 25th percentile from direct values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1.5
Exclusive percentile from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
36

FAQ

Why does PERCENTILE.EXC reject k=0 or k=1?

Exclusive percentile uses the n+1 basis and requires strictly 0 < k < 1.

Runtime metadata

Category

Statistics

Signature

PERCENTILE.EXC(arg1, arg2, ... argN: Number (Range))

This function accepts a repeating argument pattern (min args: 2).

Arity

min 2, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PURENUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

PEARSON

Returns the Pearson correlation coefficient between two paired numeric arrays.

PERCENTILE.INC

PERCENTILE.INC: Returns the k-th percentile of a data set using inclusive interpolation.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does PERCENTILE.EXC reject k=0 or k=1?Runtime metadata