Quartile Function in Google Sheets (Easiest Way to Use It in 2024)

May 8, 2024

Quartile in Google Sheets

In Google Sheets, the quartile function is used to calculate the quartile of a dataset, which is a type of quantile. The function can be used to find the value below which a certain percentage of data falls. Quartiles divide a rank-ordered data set into four equal parts. The three quartiles are first quartile (Q1), second quartile (Q2), and third quartile (Q3) which correspond to the 25th, 50th, and 75th percentiles, respectively.

Quartile Function in Google Sheets

The syntax of the quartile function in Google Sheets is as follows:

QUARTILE(data, quart)

data is the array or range containing the dataset to consider.

quart specifies which quartile to return and can take the following values:

0for the minimum value,

1 for the first quartile (25th percentile),

2 for the median or second quartile (50th percentile),

3 for the third quartile (75th percentile),

4 for the maximum value.

How to Use the Quartile Formula in Google Sheets

Follow the steps below to use the Quartile formula in Google Sheets.

1. Input Data into Google Sheets

Input the provided test scores into column A, starting from cell A2 down to A21.

2. Choose a Cell for the Quartile Output

Click on an empty cell where you'd like the quartile result to be displayed. This is where the output from our quartile formula will appear.

3. Input the QUARTILE Function with Your Data Range

In the selected cell, type in the quartile formula: =QUARTILE(A1:A20, quart). Here, A2:A21 represents the range of your dataset, and quart is the placeholder for the quartile number you want to calculate.

4. Replace quart in the Formula with the Desired Quartile Number

Decide which quartile you're calculating (1 for Q1, 2 for median/Q2, 3 for Q3, 0 for min, or 4 for max) and replace quart in the formula with that number.

5. Execute the Formula by Pressing Enter

After entering the correct formula, press Enter. Google Sheets will compute the quartile value and display it in your chosen cell.

6. Modify the Formula for Additional Quartiles as Needed

If you need to find other quartiles, just repeat the steps above, changing the quartile number in the formula accordingly.

Get Google Sheets productivity and automation tips delivered straight to your inbox

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->