Formualizer Docs
ReferenceFunctionsStatistics Functions

QUARTILE.EXC

QUARTILE.EXC: Returns an exclusive quartile value for a data set.

Summary

QUARTILE.EXC applies exclusive percentile interpolation and supports quartiles 1 through 3.

Remarks

  • Valid quartile index values are 1, 2, and 3.
  • Returns #NUM! for invalid quartile index values.
  • Returns #NUM! when the input is too small for exclusive quartile interpolation.

Examples

First exclusive quartile from direct values
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2.25
Third exclusive quartile from a range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
67.5

FAQ

Why can QUARTILE.EXC return #NUM! on small datasets?

Exclusive quartiles need enough data for valid interior rank interpolation.

Runtime metadata

Category

Statistics

Signature

QUARTILE.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

PRODUCT

Multiplies all numeric arguments and returns their product.

QUARTILE.INC

QUARTILE.INC: Returns an inclusive quartile value for a data set.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy can QUARTILE.EXC return #NUM! on small datasets?Runtime metadata