QUARTILE.EXC(array, quart)

Returns the quartile of a data set (exclusive).

arrayThe array or cell range of numeric values.
quartThe number to indicate the quartile you want to return:
1 - First Quartile (25th percentile)
2 - Median Value (50th percentile)
3 - Third Quartile (75th percentile)

* For an illustrated example refer to the page under Advanced Functions
* If "array" is empty, then #NUM! is returned.
* If "quart" is not an integer, it is truncated.
* If "quart" <= 0, then #NUM! is returned.
* If "quart" >= 4, then #NUM! is returned.
* You can use the QUARTILE.INC function to return an inclusive set.
* You can use the PERCENTILE.EXC function to return the value from a data set that corresponds to a particular percentage (exclusive).
* You can use the PERCENTRANK.EXC function to return the rank of a value as a percentage (exclusive).
* This function was added in Excel 2010
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top