PERCENTRANK.INC
ThePERCENTRANK.INC
function calculates the rank of a value in a dataset as a percentage between 0 and 1, inclusive. This function is commonly used in statistical analysis to determine the relative standing of a value within a dataset.
 How to use
PERCENTRANK.INC
formula?  Examples of using
PERCENTRANK.INC
formula PERCENTRANK.INC
formula not working? Similar formulas to
PERCENTRANK.INC
Usage
Use the PERCENTRANK.INC
formula with the syntax shown below, it has 2 required parameters and 1 optional parameter:
 data (required):
The array or range of cells representing the dataset that the value will be ranked against.  value (required):
The value to be ranked within the dataset.  significant_digits (optional):
An optional parameter that specifies the number of significant digits to use in the calculated result. If omitted, the default value is 3.
Examples
Here are a few example use cases that explain how to use thePERCENTRANK.INC
formula in Google Sheets.
Calculate percentile rank of a value in a dataset
Use PERCENTRANK.INC
to determine the percentile rank of a given value in a dataset. This can be useful for analyzing the distribution of data and identifying outliers.
Rank students based on test scores
Use PERCENTRANK.INC
to rank students based on their test scores. This can be useful for identifying the highest and lowest performing students in a class.
Analyze sales performance by region
Use PERCENTRANK.INC
to analyze sales performance by region. This can be useful for identifying regions with the highest sales and identifying areas for improvement.
Common Mistakes
PERCENTRANK.INC
not working? Here are some common mistakes people make when using the PERCENTRANK.INC
Google Sheets Formula:
Using an incorrect range
One common mistake when using the PERCENTRANK.INC
function is selecting an incorrect range of values. Make sure the range includes all of the values you want to analyze, and that the range is properly formatted with commas separating values and semicolons separating rows.
Omitting the value parameter
The PERCENTRANK.INC
function requires two parameters: the dataset to be analyzed and the value for which you want to determine the percentage rank. Forgetting to include the value parameter will result in an error.
Using a sample instead of a population
The PERCENTRANK.INC
function assumes that the supplied dataset represents the entire population, rather than a sample. If you are working with a sample, you should use the PERCENTRANK.EXC
function instead.
Related Formulas
The following functions are similar to PERCENTRANK.INC
or are often used with it in a formula:

RANK.AVG
RANK.AVG
is a statistical function that returns the rank of a specified value within a dataset. The rank is determined by comparing the value to the other values in the dataset. This function is commonly used to determine the relative position of a value within a range of values. 
RANK.EQ
The
RANK.EQ
function returns the rank of a specified value in a list of numbers. The rank of a number is its size relative to other values in the list. It is often used to determine the relative standing of values in a dataset. The function can be used to rank values in ascending or descending order, and can handle ties in several ways. 
PERCENTILE.INC
The
PERCENTILE.INC
function returns the kth percentile of a dataset, where k is a value between 0 and 1, inclusive. It returns an interpolated value if the percentile falls between two data points. This function is commonly used in statistical analysis. 
QUARTILE.INC
The
QUARTILE.INC
function calculates the quartile of a dataset, which is a measure of statistical dispersion. It is commonly used to split a dataset into four equal parts, each containing 25% of the data points. The function takes in two parameters  the dataset asdata
and the quartile number asquartile_number
 and returns the value of the specified quartile. Quartile numbers are specified as follows: 1 for the first quartile (25th percentile), 2 for the second quartile (50th percentile, or median), and 3 for the third quartile (75th percentile). 
AVERAGE
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.
Learn More
You can learn more about the PERCENTRANK.INC
Google Sheets function on Google Support.