new percentRank()
- Source
Methods
(static) exc(array, x, significance) → {number}
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
| Name | Type | Description |
|---|---|---|
array | Array.<number> | The array or range of data with numeric values that defines relative standing |
x | number | The value for which you want to know the rank. |
significance | number | Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.EXC uses three digits (0.xxx). |
- Source
the rank of a value in a data set as a percentage (0..1, exclusive) of the data set or an error if the arguments are incorrect.
- Type:
- number
(static) inc(array, x, significance) → {number}
Returns the percentage rank of a value in a data set.
| Name | Type | Description |
|---|---|---|
array | Array.<number> | The array or range of data with numeric values that defines relative standing. |
x | number | The value for which you want to know the rank. |
significance | number | Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.INC uses three digits (0.xxx). |
- Source
the percentage rank of a value in a data set or an error if the arguments are incorrect.
- Type:
- number