Quick Navigation

PERCENTILE.INC Function

Excel 2007+

Summary

The PERCENTILE.INC function calculates the k-th percentile of a dataset, where k ranges from 0 to 1 inclusive. This statistical function helps identify specific percentile values for data analysis and threshold setting.

Syntax

PERCENTILE.INC(array,k)

Parameters

Parameter	Type	Required	Description
array	`Range/Array`	Yes	Numeric data range defining relative standing
k	`Number`	Yes	Percentile position (0 to 1 inclusive)

Using the PERCENTILE.INC Function

PERCENTILE.INC is essential for statistical analysis, helping users determine percentile thresholds. Use it to find values like the 90th percentile for top performers or quality control cutoffs, with interpolation ensuring precise results even for non-integer positions.

Common PERCENTILE.INC Examples

Basic Percentile Calculation

=PERCENTILE.INC(A2:A5,0.3)

Returns 1.9 as the 30th percentile for dataset {1,3,2,4}.

90th Percentile Threshold

=PERCENTILE.INC(B2:B20,0.9)

Identifies top 10% threshold value from sales data in B2:B20.

Frequently Asked Questions

k must be between 0 and 1 inclusive. Values outside this range return #NUM! error.

PERCENTILE.INC includes endpoints (0-1), while PERCENTILE.EXC excludes them (1/(n+1) to (n-1)/(n+1)).

Common Errors and Solutions

#NUM!

Cause: Array is empty or k < 0 or k > 1

Solution: Ensure array contains numeric data and k is between 0 and 1

#VALUE!

Cause: k is non-numeric

Solution: Use a valid number for the k parameter

Notes

Interpolates linearly when k isn't a multiple of 1/(n-1)
If multiple values match the interpolated percentile, returns the largest
Array can be single column, row, or 2D range (uses all numeric values)
Available since Excel 2007

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+