QUARTILE function for Sheets

Help Center AI Assistant is now available

Got questions about Lark? Use our AI chat to find the answers.

Click and hold to drag

Got It

2 min read

I. Intro

The QUARTILE function returns the value closest to the specified quartile of the data set.

II. About the function

array (required): An array or range containing the relevant data you want to evaluate.

If quart is not an integer, then the values after the decimal point will be truncated and rounded.

When quart is equal to 0, 2, and 4, the values returned by the MIN function, MEDIAN function, and MAX function are identical to those returned by the QUARTILE function.

III. Steps

Use the QUARTILE function

Select a cell and click Formulas on the toolbar, then select Statistical > QUARTILE. You can also directly enter =QUARTILE in a cell.

The FORMULATEXT function is used to show the formula used to get the result. To learn more, visit FORMULATEXT function.

250px|700px|reset

Delete the QUARTILE function

Select the cell with the QUARTILE function, and press Delete.

IV. Use case

Sales: Divide store sales into quartiles

Quartiles are a useful statistical tool that can be used for sales analysis to evaluate the performances of different stores.

About the parameters: Enter the QUARTILE function, select a range of data, and set quart to 0, 1, 2, 3, and 4 respectively to obtain the corresponding results.

250px|700px|reset