SheetFX
≡
<< Go back to all functions

PERCENTRANK.EXC

The PERCENTRANK.EXC function in Google Sheets returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset. This function is commonly used in statistical analysis to determine the relative standing of a value within a dataset.

Function Syntax and Parameters

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

Parameters:

  • data: The range of cells or array representing the dataset.
  • value: The value for which you want to calculate the percentage rank.
  • significant_digits: [Optional] The number of significant digits to display in the result.

Step-by-Step Tutorial

  1. Using PERCENTRANK.EXC with a range of cells:

    • Example: If A1:A5 has the values 10, 15, 20, 25, 30 and you want to calculate the percentage rank for the value 22, use the formula =PERCENTRANK.EXC(A1:A5, 22).
    • Result: The result will be 0.6 (or 60%).

  2. Using PERCENTRANK.EXC with an array:

    • Example: If you have the array {1, 4, 6, 6, 10} and you want to calculate the percentage rank for the value 6, use the formula =PERCENTRANK.EXC({1, 4, 6, 6, 10}, 6).
    • Result: The result will be 0.6 (or 60%).

Use Cases and Scenarios

  1. Exam Scores: Determine the percentage rank of a student's test score compared to other students.
  2. Stock Market Analysis: Calculate the relative position of a stock price within a historical dataset.
  3. Customer Satisfaction: Evaluate the rank of a customer's satisfaction score compared to other customers.

Related Functions

  • RANK: Assign a rank to a value within a dataset.
  • PERCENTRANK.INC: Similar to PERCENTRANK.EXC, but inclusive of the specified value in the dataset.

Related Articles