Excel Function : QUARTILE
Category
Compatibility
Description
Returns the quartile of a data set
Microsoft Excel Reference Page
https://support.office.com/en-us/article/QUARTILE-function-93cf8f62-60cd-4fdb-8a92-8451041e1a2a
Syntax and Description of the QUARTILE Excel Function
The syntax for the QUARTILE function in Microsoft Excel is: QUARTILE(array, quart) Where array is the array or range of data that you want to calculate the quartile for, and quart is the quartile that you want to calculate.
About QUARTILE Excel Function
The QUARTILE function in Excel returns the quartile of a given data set. The quartile is the value that is at the 25th, 50th, or 75th percentile of a data set. The function can be used to find the first, second, or third quartile of a data set.