Statistical - QUARTILE.EXC Function

Description

The QUARTILE.EXC function returns the quartile of the data set, based on percentile values from 0...1, exclusive.

Syntax

QUARTILE.EXC (array, quart)

Arguments

Argument Description Required/ Optional
Array The array or cell range of numeric values for which you want the quartile value. Required
Quart Indicates which value to return. Required

Notes

  • If quart is not an integer, it is truncated.

  • MIN, MEDIAN, and MAX return the same value as QUARTILE.EXC when quart is equal to 0 (zero), 2, and 4, respectively.

  • If array is empty, QUARTILE.EXC returns the #NUM! error value.

  • If quart ≤ 0 or if quart ≥ 4, QUARTILE.EXC returns the #NUM! error value.

  • If array has fewer than 3 values, and quart is equal to 1 or 3, QUARTILE.EXC returns the #NUM! error value.

  • If the value of quart cannot be interpreted as a numeric value, QUARTILE.EXC returns the #VALUE! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

Quartile.Exc Function
advanced_excel_statistical_functions.htm
Advertisements