PERCENTRANK.INC

The PERCENTRANK.INC function in Google Sheets returns the percentage rank (percentile) from 0 to 1, inclusive, of a specified value in a dataset.

Function Syntax and Parameters

Syntax: PERCENTRANK.INC(data, value, [significant_digits])

Parameters:

data: The range or array containing the dataset for which the percentile rank needs to be calculated.
value: The value for which the percentile rank needs to be calculated.
significant_digits: [Optional] The number of significant digits for the calculated percentile rank. The default value is 3.

Using PERCENTRANK.INC with a range of cells:
- Example: If A1:A10 contains the dataset [10, 20, 30, 40, 50, 60, 70, 80, 90, 100], and you want to find the percentile rank of the value 50, then the formula =PERCENTRANK.INC(A1:A10, 50) will return 0.5.
Using PERCENTRANK.INC with an array:
- Example: If {1, 2, 3, 4, 5} is the array and you want to calculate the percentile rank of the value 4, then the formula =PERCENTRANK.INC({1, 2, 3, 4, 5}, 4) will also return 0.5.

Exam Results Analysis: Determine the percentile rank of a student's score in comparison to other students.
Stock Performance Evaluation: Calculate the percentile rank of a stock's returns among other investments.
Customer Satisfaction Survey: Find the percentile rank of a customer's satisfaction score compared to others.

PERCENTILE: Calculate the nth percentile value in a dataset.
PERCENTRANK.EXC: Similar to PERCENTRANK.INC, but excludes the endpoints in the calculation.

N/A