Percentiles divide the data set into parts. Usually, the nth percentile has n% of the observations below it, and (100-n)% of observations above it.

Syntax

PERCENTILE(number,probability)

Calculates the sample percentile, for a specified probability and number (the column containing the sample data). Missing values are ignored. The probability must be between 0 and 1, inclusive, and indicates the percentile. For example, to determine the 1st quartile (25th percentile) of a column of data, enter the column number and the probability 0.25.

Example

Column

Calculator expression

Result

C1 contains 2, 3, 5, and 7

PERCENTILE (C1,0.25)

2.25

By using this site you agree to the use of cookies for analytics and personalized content. Read our policy