QUARTILE function - Zoho Sheet - Help Guide

QUARTILE

Returns the value for a specified quartile in a given data set.

 

Syntax

 

QUARTILE(number_list; q)

number_list: The data set given as input. Eg., A2:A6

q: The quartile number whose data you want.

0 - Minimum value (0%)

1 - First quartile (25%)

2 - Median value (50%)

3 - Third quartile (75%)

4 - Maximum value (100%)  

Remarks

  • The QUARTILE function returns the same result as that of MIN, MEDIAN, and MAX when the q value equals 0, 2, and 4 respectively.

  • This function has been replaced by QUARTILE.INC. Though Zoho Sheet currently supports this function, we recommend using the new function as QUARTILE function support may be removed in the future.

Examples

 

Formula

Result

=QUARTILE(A2:A6;B2)

13

=QUARTILE(A2:A6;B3)

8

=QUARTILE(A2:A6;B4)

21


Get a hands-on experience of the function in the embedded range below.   



Possible Errors

 

Errors

Meaning

#N/A!

  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.

#NAME!

  • The function name is incorrect or invalid.

  • The given defined name (if any) is invalid.

  • There is a typo in the defined name used in the function.

  • Double quotes are missing for text values in the function.

  • Colon missing in a cell range reference.

#VALUE!

  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.

#REF!

  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.

#NUM!

  • The given array is empty.

  • The value of q is not between 0 and 4.

 

Similar Functions

  • AVERAGE

  • AVERAGEA

  • AVERAGEIF

  • AVERAGEIFS

  • GEOMEAN

  • HARMEAN

  • LARGE

  • MAX

  • MAXA

  • MEDIAN

  • MIN

  • MINA

  • PERCENTILE

  • PERCENTRANK

  • RANK

  • SMALL

  • TRIMMEAN