# Difference between revisions of "Manuals/calci/PERCENTILE"

Jump to navigation
Jump to search

Line 20: | Line 20: | ||

2 | 2 | ||

9 | 9 | ||

− | PERCENTILE(C1:C4,0.4)=5.4 | + | PERCENTILE(C1:C4,0.4) = 5.4 |

#15 | #15 | ||

20 | 20 | ||

Line 26: | Line 26: | ||

41 | 41 | ||

35 | 35 | ||

− | PERCENTILE(D1:D5,0.721)=33.26 | + | PERCENTILE(D1:D5,0.721) = 33.26 |

#2 | #2 | ||

3 | 3 | ||

4 | 4 | ||

− | PERCENTILE(A1:A3,1.1)=NAN | + | PERCENTILE(A1:A3,1.1) = NAN |

==See Also== | ==See Also== |

## Revision as of 03:48, 7 January 2014

**PERCENTILE(ar,k)**

- is the array of data .
- is the Percentile value.

## Description

- This function gives the percentile value in a given range.
- Percentile means any of the 100 equal parts into which the range of the values of a set of data can be divided in order to show the distribution of those values.
- The percentile of a given value is determined by the percentage of the values that are smaller than that value.
- For example we can have the percentile is the value below which 25 percent of the observations may be found.
- The 25th percentile is called as the first quartile (Q1), the 50th percentile as the median quartile (Q2), and the 75th percentile as the third quartile (Q3).
- In general, percentiles and quartiles are specific types of quantiles.
- In , is the array of data that indicating relative standing and is the Percentile value in the range (inclusive).
- This function will return the result as error when

1. The array value is empty. 2. is non-numeric or or .

## Examples

- 5

7 2 9 PERCENTILE(C1:C4,0.4) = 5.4

- 15

20 12 41 35 PERCENTILE(D1:D5,0.721) = 33.26

- 2

3 4 PERCENTILE(A1:A3,1.1) = NAN