This function returns the kth percentile of values in a range where k is between 0..1, exclusive
- 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
Array of values representing the data
Value representing the percentile value between 0 and 1
This function is the same as the Microsoft Excel 'PERCENTILE.EXC' function - using the same inputs, logic and outputs.