Excel Function : PERCENTILE.INC

Download now!

Excel Function : PERCENTILE.INC

Category

Statistical

Description

Returns the k-th percentile of values in a range

Microsoft Excel Reference Page

https://support.office.com/en-us/article/PERCENTILEINC-function-680f9539-45eb-410b-9a5e-c1355e5fe2ed

Syntax and Description of the PERCENTILE.INC Excel Function

PERCENTILE.INC(array, k) The PERCENTILE.INC function returns the k-th percentile of values in a data set. For example, the 20th percentile is the value (or score) below which 20% of the data falls.

About PERCENTILE.INC Excel Function

The PERCENTILE.INC function returns the k-th percentile of values in a data set. The k-th percentile is the value at which k percent of the data is below that value.