PERCENTILE.INC function - Function returns the kth percentile of values in the range with k in the range from 0 to 1 in Excel

PERCENTILE function - The function returns the kth percentile in Excel
PERCENTILE.EXC function - The function returns the kth percentile of values in the range, with k in the range from 0 to 1 in Excel

The following article introduces you to the PERCENTILE.INC function - one of the functions in the statistical function group is very popular in Excel.

PERCENTILE.INC function - Function returns the kth percentile of values in the range with k in the range from 0 to 1 in Excel Picture 1

Description: The function returns the kth percentile of values in the range with k between 0 and 1.

Syntax: PERCENTILE.INC (array, k)

Inside:

- array: An array or range of data to determine percentile, which is a required parameter .

- k: Percentage value in the range from 0 to 1 including 0 and 1, is a required parameter .

Attention:

- If array array value is empty -> the function returns the #NUM! Error value .

- If the value of k is not a number -> the function returns the error value #VALUE! .

- If k ≤ 0 or k ≥ 1 -> the function returns the #NUM! Error value

- If k is not a multiple of 1 / (n - 1) -> interpolation function to determine the kth percentile value.

- PERCENTILE.EXC function will interpolate when the percentile return value is between two values in the array. Where the function cannot be interpolated -> the function returns the #NUM! Error value

For example:

Find the value of 0.56 percentile in the dataset in the data table below:

PERCENTILE.INC function - Function returns the kth percentile of values in the range with k in the range from 0 to 1 in Excel Picture 2

- In the cell to calculate enter the formula : = PERCENTILE.EXC (E6: K6,0.56)

PERCENTILE.INC function - Function returns the kth percentile of values in the range with k in the range from 0 to 1 in Excel Picture 3

- Press Enter -> 0.56 percentile value in the dataset is:

PERCENTILE.INC function - Function returns the kth percentile of values in the range with k in the range from 0 to 1 in Excel Picture 4

- With PERCENTILE.EXC function, the first 2 values 0 and 1 within the function still perform calculations.

+ With value k = 1:

PERCENTILE.INC function - Function returns the kth percentile of values in the range with k in the range from 0 to 1 in Excel Picture 5

+ With value k = 0:

PERCENTILE.INC function - Function returns the kth percentile of values in the range with k in the range from 0 to 1 in Excel Picture 6

Above are instructions and some specific examples when using PERCENTILE.INC function in Excel.

Good luck!

David Pac

Update 19 May 2020

You should read it

May be interested

STDEV.P function - The function returns the standard deviation based on the whole in Excel
stdev.p: the function returns the standard deviation based on the whole population, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.p (number1, [number2] ,.
RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
rank.avg function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the average rank. support functions from execl 2010 version and above
How to use the Match function in Excel
the match function on excel looks for a value defined in an array, cell range on the data table and returns the position of the value in the array, that range.
PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
percentrank.inc function: the function returns the rank of a value in a dataset as a percentage including values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.inc (array, x, [significance])
PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
percentrank.exc function: the function returns the rank of a value in a dataset as a percentage excluding values 0 and 1. the function supports excel 2010 and later versions. syntax: percentrank.exc (array, x, [significance])
STDEV.S function - The function returns the standard deviation based on a sample in Excel
stdev.s function: the function returns the standard deviation based on a sample, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.s (number1, [number2], ...)
GEOMEAN function - The function returns the average of a positive array or range of data in Excel
geomean function: the function returns the average of a positive array or range of data. use the function to calculate the average growth when knowing the gross profit with variable interest rates. syntax: geomean (number1, [number2], ...)
TREND - The function returns values in a linear trend in Excel
trend: the function returns values in a linear trend. syntax: trend (known_ys, [known_xs], [new_xs], [const])
MAXA function - The function returns the largest value in a set of values including text and logical values in Excel
maxa function: the function returns the largest value in a set of values including text and logical values. syntax: maxa (value1, [value2], ...)
BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel
binom.dist.range function: the function returns the probability of a test result using binomial distribution. support functions from the excel 2010 version. syntax: binom.dist.range (trials, probability_s, number_s, [number_s2])