PERCENTILE.INC
Returns the k-th percentile of values in a range.
=PERCENTILE.INC(array, k)This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.
What the function does
Overview
Returns the k-th percentile of values in a range.
PERCENTILE.INC calculates the k-th percentile of values in a range, where k is in the closed interval [0, 1]. The .INC suffix signifies that the calculation inclusive of the 0th (minimum) and 100th (maximum) percentiles, making it suitable for datasets where the inclusive boundaries are meaningful for the distribution analysis. If the requested percentile (k) does not correspond to an exact data point, the function uses linear interpolation between values to determine the result. This function is vital for statistical analysis, such as identifying the top 10% of performers in a test or determining a 95th percentile response time for server latency. Best practices include ensuring the array contains numeric values only and ensuring k is between 0 and 1 inclusive. For very small datasets, interpolation may produce results that do not exist within the original data set.
Quick reference
Syntax
=PERCENTILE.INC(array, k)Inputs
Arguments
Example: B2:B100
Example: 0.9
Formula patterns
Examples
Calculate the 90th percentile of test scores
=PERCENTILE.INC(A2:A51, 0.9)Find the median value using the 50th percentile
=PERCENTILE.INC(B2:B200, 0.5)Determine the 75th percentile (third quartile) of sales
=PERCENTILE.INC(C2:C500, 0.75)Avoid these issues
Common Errors
#NUM!
Cause: Supplied k value is < 0 or > 1, or the provided array is empty.
Fix: Ensure the k argument is a decimal between 0 and 1 (inclusive) and the range contains numeric data.
#VALUE!
Cause: The k argument is non-numeric.
Fix: Check that the second argument is a number or a cell reference containing a valid number.
Platform support
Compatibility
Source: Microsoft Support
Common questions
Frequently Asked Questions
Returns the k-th percentile of values in a range.
array: Data range k: Percentile value (0 to 1)
#NUM!: Ensure the k argument is a decimal between 0 and 1 (inclusive) and the range contains numeric data. #VALUE!: Check that the second argument is a number or a cell reference containing a valid number.