Value at a Given Percentile Calculator

How it is calculated

The values are sorted from smallest to largest, with n the number of values. The tool then computes a zero-based rank r = p ÷ 100 × (n − 1), so the smallest value sits at rank 0 and the largest at rank n − 1. If r falls between two positions, the answer is interpolated: value = x⌊r⌋ + (r − ⌊r⌋) × (x⌊r⌋+1 − x⌊r⌋). At p = 0 you get the minimum and at p = 100 the maximum. This is the inclusive method that spreadsheet PERCENTILE.INC uses; other methods give slightly different numbers for small data sets. Separate values with spaces or commas, with a dot as the decimal mark (a comma always splits numbers). The percentile must be from 0 to 100, and any non-numeric item stops the calculation.

Common mistakes

• Typing a decimal comma such as 2,5 in the list: a comma separates values, so it is read as the two numbers 2 and 5; use 2.5.
• Entering the percentile as a fraction (0.9) instead of a number from 0 to 100: 0.9 gives the 0.9th percentile, close to the minimum.
• Expecting the result to be one of your data values: it is interpolated, so 26.50 is not in the list, which is normal.
• Comparing the result with another tool without checking its method: some use rank p × (n + 1) and give a different answer on small samples.
• Reading the rank position as a 1-based position: it starts at 0 for the smallest value.