How To Find Quartiles In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to find quartiles in Google Sheets.

In statistics, quartiles are cut points that divide the number of data points in a data set into quarters of equal size.

For example, the second quartile is the same as the median of a dataset. This means there are equal numbers of data points above and below the second quartile. In the same way that the second quartile splits the entire data set, the first and third quartiles split the top and bottom halves of the dataset created by the second quartile.

Fortunately, you don’t have to handle all that math yourself when finding quartiles in Google Sheets. Just follow these steps:

Step 1

Select a cell to calculate quartile in and type the following formula: “=QUARTILE(A2:A16, 1)”. The range A2:A16 references the dataset you want to find the quartile for, and the second parameter (1 in this example) is the quartile number parameter and specifies the quartile to find.

Step 2

Calculate first, second and third quartiles using the digits 1, 2, and 3 respectively for the quartile number parameter

Step 3

You can also use digits 0 or 4 to calculate the min and max values of the dataset


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to find quartiles in Google Sheets. Want more? Check out all the Google Sheets Tutorials.