PERCENTILE.INC (PQL - xl)

This function returns the kth percentile of values in a range where k is between 0..1, inclusive

  • 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

PERCENTILE.INC(array, k)

Function Arguments

Name

Description

Type

Optional

array

Array of values representing the data

StringOrNumber

k

Value representing the percentile value between 0 and 1

Number

Comments

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