 Excel Functions

# Excel QUARTILE.EXC Function

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)

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

### Availability

Since 2010 for Windows.
Since 2011 for Mac.

#### Related Posts

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…