Excel Function : QUARTILE.INC
Category
Statistical
Description
Returns the quartile of a data set
Microsoft Excel Reference Page
https://support.office.com/en-us/article/QUARTILEINC-function-1bbacc80-5075-42f1-aed6-47d735c4819d
Syntax and Description of the QUARTILE.INC Excel Function
The QUARTILE.INC function in Excel returns the quartile of a data set, based on percentile values that you specify. The function uses the following syntax: QUARTILE.INC(array, quart) Where array is the data set and quart is the quartile value that you want to return. For example, if you want to return the first quartile of a data set, you would specify a quartile value of 1.
About QUARTILE.INC Excel Function
The QUARTILE.INC function returns the k-th percentile of values in a data set. This function is an inclusive version of the QUARTILE function, meaning that the result includes the value at position k in the data set.