Percent Rank


The PERCENTRANK function calculates the percent rank for each value in a set of input values. Specifically, the function computes the percentage of all input values that are less than a given input value. Percent Rank values range between 0 and 1.

Percent Rank
Percent Rank

1. Syntax


2. Input

The Percent Rank function requires the following input:

  • d0 - The set of data values for which the Percent Rank is calculated.

3. Parameters

The Percent Rank function requires the following parameters.

  • s0 - Indicates whether to include the two extreme percent values in the calculation. Default value is True.

4. Output

The Percent Rank function generates the following output:

  • Percent Rank - The Percent Rank result set.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri