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

## Summary

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.

#### More basic math formulas in Google Sheets:

- Addition
- Subtract
- Multiply
- Divide
- Exponents
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- FREQUENCY
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Percentages
- SUMIF
- Round Down
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Median
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Trimmean
- Sum Columns or Rows
- Sumif
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula