We raised a $20m Series A led by Coatue + Accel! Click here to read the announcement.

Google Sheets

PERCENTILE.EXC is used to calculate the percentile rank of a value in a set of data. The function takes in two arguments: the value you want to find the percentile rank for, and an array of data. It will then return the percentile rank of the value you entered, as well as the value's rank in the array.

In Google Sheets, the syntax of PERCENTILE.EXC is as follows:

=PERCENTILE.EXC(array,percent)

This function takes two arguments: an array and a percentage. It returns the percentage of the values in the array that are equal to or greater than the percentage specified.

The PERCENTILE.EXC function in Google Sheets can be used to calculate the percentile rank of a value in a given set of data. This function takes a single input, which is the value that you want to find the percentile rank for, and returns the percentile rank of that value within the set of data. This function can be used to compare values and find out which ones are in the top or bottom percentiles.

There are a few occasions when you should not use the PERCENTILE.EXC function in Google Sheets. One such occasion is when you are trying to calculate the percentile rank of a value that is less than zero. In this case, the PERCENTILE.EXC function will return an error. Another time you should not use the PERCENTILE.EXC function is when you are trying to calculate the percentile rank of a value that is greater than or equal to 100. In this case, the PERCENTILE.EXC function will return the value 100.

The following are some similar formulae to PERCENTILE.EXC in Google Sheets:

PERCENTILE.INC: Calculates the percentile of a value relative to a given rank.

RANK.AVG: Returns the rank of a number within a list of numbers.

RANK.EQ: Returns the rank of a number within a list of numbers, treating ties as equal.

Get started with Causal today.

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

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