Excel Function : QUARTILE.INC

Download now!

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.