If you need to calculate the quartiles for your dataset in Google Sheets, there is a built-in function to do this called the QUARTILE function.
In this tutorial, I will show you how to find the quartiles in Google Sheets by using the QUARTILE function.
The QUARTILE function will return the value that is closest to a specified quartile of a dataset.
The syntax of the QUARTILE function is:
- data – this is the array or range containing the data that will be used to find the quartile
- quartile_number – this tells the formula which quartile to return
- 0 – this will return the minimum value in the data (0%)
- 1 – this will return the data nearest to the first quartile (25%)
- 2 – this will return the data nearest to the median (50%)
- 3 – this will return the data nearest to the third quartile (75%)
- 4 – this will return the maximum value in the data (100%)
Using the QUARTILE Function
Now that we have learned the basic syntax of this function, let’s take a look at how it will be used in a spreadsheet with some example data:
In the example data above, I have the 5 QUARTILE functions that each result in a different quartile number. You can see in the example that this function is very easy to use, you just need to put your data as the first argument, and then which quartile to return as the second argument.
The QUARTILE function is very easy to use and is much faster than calculating the quartile manually.
In a matter of seconds, you can use this function in your spreadsheet to give you some important information on the quartiles in your dataset.
Try using this function in your own spreadsheet so that you really get this down and you will certainly find it will come in handy in the future as you continue to work in spreadsheets.