Percentile

The Percentile function returns the n^th percentile of values in a column of numbers.

Percentile (numbers, n, break_col)

where:

numbers references the column that contains the numbers on which the percentile is calculated.

n is the percentile value 0 to 1 inclusive.

break_col is an optional parameter that references a break column.

The following examples show the results of inserting the Percentile function in three separate tables.

Example 1

In this example, two computed value columns have been calculated. In the first computed column, the Percentile function is used on the numeric column and the n^th percentile of values (.80 in this case).

Percentile (Units, .80)

In the second computed column, the Percentile function is used on the numeric column, the n^th percentile of values (.80 in this case), and the break_column.

Percentile (Units, .80, State)

Example 2

In this example, two computed value columns have been calculated. In the first computed column, the Percentile function is used on the numeric column and the n^th percentile of values (0 in this case).

Percentile (Units, 0)

In the second computed column, the Percentile function is used on the numeric column, and the n^th percentile of values (.25 in this case).

Percentile (Units, .25)