PercentRank

Syntax

PercentRank(Data, Value, Significance)

Parameters

Data. Data array that determines relative position.

Value. Value, percentage for which is determined.

Significance. Optional value determining the number of meaningful numbers for the returned percent value. The value must satisfy the constraint: Significance >= 1.

Description

The method returns value category in a data set as a percentage in this data set.

Comments

This function can be used to evaluate the relative standing of a data point within a data set.

If the specified Value does not match any of the Data argument values, the PercentRank function performs interpolation and returns the adjusted percentage value.