QUARTILE Function - Microsoft Support

Home » How To Find Iqr In Excel » QUARTILE Function - Microsoft Support

Maybe your like

Syntax

QUARTILE(array,quart)

The QUARTILE function syntax has the following arguments:

  • Array     Required. The array or cell range of numeric values for which you want the quartile value.

  • Quart     Required. Indicates which value to return.

If quart equals

QUARTILE returns

0

Minimum value

1

First quartile (25th percentile)

2

Median value (50th percentile)

3

Third quartile (75th percentile)

4

Maximum value

Tag » How To Find Iqr In Excel