percentile

Manual -> Report Generator -> Engineering in the Editor -> Report functions -> Statistical functions -> percentile
Previous chapterNext chapter Show allShow all    Hide allHide all

The function percentile (range,num) returns as result a threshold value, from which the values are accepted.

Syntax: =percentile(range,num)

Range: is a matrix or a data range, that describes the relative position of the data.

num: Integer from 0-100

Example Example

Cells A1 to A10: any numbers

Cell B1 = percentile(A1:A10,90)

R / C

A

B

1

1

9,1

2

2

3

3

4

4

5

5

6

6

7

7

8

8

9

9

10

10