PERCENTILE(R, N)

 

Description

This function returns the value in the range R that is at the Nth percentile in R.  Only numeric data in R is considered.  The result is interpolated if N is not a multiple of 1/(s-1), where s is the size of R.

 

Parameters

 

R

A range of data.

 

N

A numeric value between 0 and 1, inclusive.

 

Examples

 

PERCENTILE(A1:A4, 0.65) = 2.95

Where A1:A4 = 1, 2, 3, 4.

 

PERCENTILE(B1:B6, 0.75) = 21.35

Where A1:A6 = 3.8, 23, 4, 12, 67, 0.2.