﻿ Formula Reference > Spreadsheet Formula Functions > QUARTILE.INC
 Navigation:  Formula Reference > Spreadsheet Formula Functions > QUARTILE.INC

This function returns the quartile (which quarter or 25 percent) of a data set based on percentile values from 0..1, inclusive.

Syntax

QUARTILE.INC(array,quart)

Arguments

This function has these arguments:

 Argument Description array Array or cell range of numeric values for which you want the quartile value quart Quartile value for the array (see the table below for returned values)

Remarks

A quarter is 25 percent. So the quartile number is an integer between 0 (the minimum value in the data set) and 4 (the maximum value in the data set) and determines the value to return as listed in the table below. quart is truncated if it is not an integer. If quart is < 0 or > 4 the #NUM! error value is returned.

 If the number is... Then this function returns the... 0 Minimum value 1 First quartile (25th percentile) 2 Median value (50th percentile) 3 Third quartile (75th percentile) 4 Maximum value

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

QUARTILE.INC(A1:A17,2)

QUARTILE.INC(R1C1:R17C1,3)

QUARTILE.INC({11,21,42,27,18,29,32,52},1) gives the result 20.25