Excel Function : QUARTILE

Download now!

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.