QUARTILE

**Syntax:** **QUARTILE( R, Q)**

*R* = Range of cells

*Q* = Quartile as follows:

0 | Minimum value |

1 | First quartile (25th percentile) |

2 | Second quartile (50th percentile) |

3 | Third quartile (75th percentile) |

4 | Maximum value |

**QUARTILE** finds the quartile *Q* of the data in range *R*.
This is equivalent to **PERCENTILE**(*R*, *Q*/4).

**Examples:**

A1..A8 = 1, 2, 4, 7, 8, 9, 10, 12

**QUARTILE**(A1..A8, 2) = 7.5

**QUARTILE**(A1..A8, 1) = 3.5

**Excel function:** QUARTILE

Grey Trout Software

02 March 2003