Excel Functions

Excel QUARTILE.EXC Function

Pinterest LinkedIn Tumblr

The Excel QUARTILE.EXC Function stands for quartile exclusive.This excel function is categorised under the staistical function. A quartile is a type of quantile which divides the number of data points into four more or less equal parts, or quarters

Purpose of Excel QUARTILE.EXC Function

The function can be used in revenue analysis.This function does not gives minimum and maximum value as it is exclusive of 0 to 1.

Return value

Returns the quartile of given data on percentile value 0.1, exclusive. Its calculation is based on a percentile range of 0 to 1 (exc).

Syntax

= QUARTILE.EXC(array,quart)

Arguments

ArgumentsDescriptionRemarks
array List of value to calculate quartile.Mandatory
quart Indicate which value to return.
Mandatory

Usage notes

  • This function returns the #NUM! error value,if the array is empty.
  • It will be truncated, if the quart is not an integer.
  • If the supplied value of quart is < 1 or > 3, #NUM! error will occur.
  • If the supplied array is empty,#NUM! will occur.
  • #VALUE! error occurs if the supplied value of quart is non-numeric.
IF QUARTILE EQUAL QUARTILE.EXC RETURNS
1 First quartile point – 25th percentile
2 Median value – 50th percentile
3 Third quartile – 75th percentile

Availability

Since 2010 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment