Statistical - QUARTILE.INC Function



Description

The QUARTILE.INC function returns the quartile of a data set, based on percentile values from 0...1, inclusive.

Syntax

QUARTILE.INC (array,quart)

Arguments

Argument Description Required/ Optional
Array The array or cell range of numeric values for which you want the quartile value. Required
Quart Indicates which value to return Required

Notes

  • If quart is not an integer, it is truncated.

  • MIN, MEDIAN, and MAX return the same value as QUARTILE.INC when quart is equal to 0 (zero), 2, and 4, respectively.

  • If array is empty, QUARTILE.INC returns the #NUM! error value.

  • If quart < 0 or if quart > 4, QUARTILE.INC returns the #NUM! error value.

  • If the value of quart cannot be interpreted as a numeric value, QUARTILE.INC returns the #VALUE! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

Quartile.Inc Function
advanced_excel_statistical_functions.htm
Advertisements