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

QUARTILEEXC

Returns the specified quartile of a dataset, based on percentile values from 0..1, exclusive.

Sample Usage

QUARTILE.EXC(A2:A25,1)
QUARTILE.EXC(A2:A25,3)

Syntax

QUARTILE.EXC(range, quartile)

  • range - The range containing the dataset.
  • quartile - The quartile value to return.

Examples

QUARTILE.EXC(A2:A25,1) locates the position of the first quartile.
QUARTILE.EXC(A2:A25,3) locates the position of the third quartile.

 

Notes

  • If quartile is not an integer, it is truncated. 
  • quartile must be between 0 and 4, exclusive.
  • 0 returns the minimum value in range (0% mark).
  • 1 returns the value in range closest to the first quartile (25% mark).
  • 2 returns the value in range closest to the second quartile (50% mark).
  • 3 returns the value in range closest to the third quartile (75% mark).
  • 4 returns the maximum value in range (100% mark).
  • QUARTILE.EXC calculates quartile based on a quartile range exclusive of 0th and 4th quartile.