Excel: determine percentiles, quartiles, quintiles - how it works
Excel provides its own functions for calculating the position dimensions percentiles, quartiles and quintiles in an Excel statistic. You can read the exact determination in this article.
Determine quartiles and quintiles in Excel - how it works
- Select the field in which you want to determine the quartile or quintile.
- Write an equal sign in the upper field for formulas and enter "QUANTILE". The function is now proposed to you.
- As the first argument, enter in the brackets the range of values to be taken into account when determining the quartile.
- The second argument is separated by a semicolon and shows how many quartiles it should be: For example, if you want to calculate the 3rd quartile, enter "= QUANTILE (...; 3)". The result indicates what percentage of the values are below 75 percent.
Calculate percentiles with Excel - how it works
There is no separate function for percentiles in Excel. Instead, you have to calculate a multiple of the quartiles or quintiles:
- For example, if you want to calculate the 25th percentile, enter "= QUANTILE (...; 1)".
- For the 5th percentile enter "= QUANTILE (...; 0.2)" accordingly, for the 1st percentile "= QUANTILE (...; 0.4)".
The next page explains how to create a histogram in Excel.