Excel

PERCENTILE: Excel Formulae Explained

How do you use PERCENTILE in Excel?

The PERCENTILE function in Excel returns the kth percentile of a given set of data. For example, if you want to find the 80th percentile of a set of numbers, you would use the PERCENTILE function and input 80 as the kth argument. The function will then return the number that is at the 80th percentile of the given set of data.

What is the syntax of PERCENTILE in Excel?

The syntax of the PERCENTILE function in Excel is as follows:

=PERCENTILE(array,k)

Where:

array is the range of cells to be evaluated

k is the percentile to be returned

What is an example of how to use PERCENTILE in Excel?

The PERCENTILE function in Excel is used to calculate the percentile rank of a value in a given set of data. The function takes as input the value you wish to find the percentile for, as well as the list of values from which to calculate the percentile. It then calculates the rank of the input value within the set of data, and returns the percentage of values in the set that are equal to or less than the input value. An example use of the function would be to find the 95th percentile rank for a given set of test scores. This would be done by inputting the test score into the function, and then providing the list of test scores as the second argument.

When should you not use PERCENTILE in Excel?

There are a few instances when you should not use the PERCENTILE function in Excel. One is when you are trying to find the rank of a number in a set of data. Another is when you want to find the percentage of a number in a set of data. In both of these cases, you should use the RANK and PERCENTILE.RANK functions, respectively.

What are some similar formulae to PERCENTILE in Excel?

The most similar formula to PERCENTILE in Excel is the QUARTILE function. The QUARTILE function takes a list of numbers as an input and returns the quartile of the given list. The quartiles are the numbers that divide the list into four equal parts. The first quartile is the number that is greater than or equal to the first 25% of the numbers in the list, the second quartile is the number that is greater than or equal to the first 50% of the numbers in the list, and the third quartile is the number that is greater than or equal to the first 75% of the numbers in the list. The fourth quartile is the number that is greater than or equal to the first 100% of the numbers in the list.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.