Percentile calculator

This percentile calculator calculates individual percentiles, percentile tables, percentile charts, and provides solutions.

The data should be separated by a line break or a comma. You may paste from Excel. The tool ignores empty cells or non-numeric cells.

Percentile calculator

Percentile calculator - with solution, calculates the percentile of sample data, draws percentile charts, and generates the percentiles table.

How to use the percentile calculator

The tool uses to create 'percentile', also called a 'percentile score' or 'centile':

  1. Enter delimited data
    • You can copy the data from Excel and paste it into the calculator.
    • You can choose the data delimiter under 'more options'.
  2. Choose the required percentile.
  3. Determine the percentile table increment value.
  4. Press the 'calculate' button.
  5. After generating the plot, you will find the solution and customization buttons located below the plot.
  6. The percentile calculator offers the option to exclude outliers using Tukey's fences method for better clarity.

Fields

  1. Data: Enter the delimited data, you may change the delimited data under 'More options'
  2. Percentile rank: Select the percentile you want to see.
  3. Percentile table increment: This setting determines the spacing between percentiles shown in both the 'percentile table' and 'percentile band chart'. However, the 'percentile band chart' has a minimum increment of 5. If you choose a smaller increment, the 'percentile table' will use your chosen increment, but the 'percentile band chart' will be created with increments of 5.

Options

  1. Percentile rank chart: Line color
  2. Outliers: While you may exclude outliers, it is important to note that doing so is generally not recommended unless you understand the cause of each outlier.
  3. Percentile rank name: You can customize the 'Percentile' label for both the table and charts.
  4. Value name: You can customize the 'Value' label for both the table and charts.
  5. Data delimiters: This option defines the character(s) separating values in your data. Common choices include comma, tab, space, or Enter key. You can also specify a custom delimiter if needed.
  6. Customize percentile band chart colors: Customize percentile band chart colors: You can either set colors for each band individually, or run the chart initially. Then, create a custom color palette for further customization. Once the palette is created, you can still adjust individual colors as needed.
'Percentile band chart' more options:

After calculating percentiles, you can customize the following options for the 'percentile band chart':

  1. You can create a gradient palette of colors from 'From color' toward 'To color' with 'Increment level' steps.
  2. Font size: You can adjust the font size of the numbers. The labels will be automatically set 20% larger than the numbers.

What is percentile rank (PR) ?

The percentile rank of a value corresponds to the percentage of values in the population that are lower than the given value.

What is percentile?

The percentile, also called the percentile score, represents a value that is greater than or equal to the specified percentile rank percentage of the other values. The percentile is the inverse of the CDF.

Percentile rank formula

PR = 100 *Rank - 1
Sample Size - 1

What is 95th percentile?

The 95th percentile score represents a value that is greater than or equal to 95 percent of the other values.

Percentile formula

Rank =PR * (Sample Size - 1)+ 1
100

The percentile is the value with the rank above rank.
When the rank is not integer we calculate the percentile using the following formula:

Rank = Integer + Decimal
Percentile = Number(Integer) + Decimal*(Number(Integer + 1) - Number(Integer))

Percentile example

Calculate the 75th percentile of the following list:
15,4,13,2,3,4,18,5,6,7

1. Sort the numbers in ascending order:
2,3,4,4,5,6,7,13,15,18

2. Calculate the index of the percentile:
Rank =Percentile Rank * (Sample Size - 1)+ 1
100
Rank =75 * (10 - 1)+ 1 = 7.75
100
3. The result is the interpolation of the 7th number: 7 and the 8th number: 13.
Percentile = 7 + 0.75*(13 - 7) = 11.5.