PERCENTRANK.INC (PQL - xl)

This function returns the rank of a value in a data set as a percentage of the data set

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

PERCENTRANK.INC(array, x, OPTIONAL significance)

Function Arguments

Name

Description

Type

Optional

array

Array of data with numeric values that defines the relative ranking

StringOrNumber

x

Value for which you want to find the rank in percentage

Number

significance

Number of significant digits for the ranked percentage value; if omitted, the calculation uses three significant digits; if not an integer, number is truncated

Number

Y

Comments

This function is the same as the Microsoft Excel 'PERCENTRANK.INC' function - using the same inputs, logic and outputs.