PERCENTILE

Computes nth percentile of a list of numbers

PERCENTILE(nth, column )

Computes nth percentile of a list of numbers, ignoring any blank values.

Arguments

Argument

Description

nth

Desired percentile as a decimal (0 <= nth <= 1)

column

numeric column

Outputs

Desired percentile of input values

Example

Last updated