Percentile()
Summary
Returns the value at which a given percentile is reached.
Syntax
pct_value = Percentile(array input_values, integer pctile)
| Argument | Contents |
|---|---|
| input_values | An array of numbers |
| pctile | The desired percentile value, from 0 to 100 |
Returns
A real number indicating the value at which the percentile is reached.
Notes
-
The array must contain numbers only. Other types, including null, are not allowed.
Error Codes
| Error Type | Meaning |
|---|---|
| Error | The array contains values that are null or are not numbers |
See Also
| Function | Summary |
|---|---|
| Mean() | Computes the mean (average) of the elements of an array |
| Median() | Computes the median of the elements of an array |