Manuals/calci/PERCENTILE

Revision as of 14:02, 8 June 2018 by Devika (talk | contribs)
PERCENTILE (Array,kth)


  • 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

1.

Spreadsheet
A B C D
1 5 7 2 9
=PERCENTILE(A1:D1,0.4) = 5.4

2.

Spreadsheet
A B C D E
1 15 20 12 41 35
=PERCENTILE(A1:E1,0.721) = 33.26

3.

Spreadsheet
A B C
1 2 3 4
=PERCENTILE(A1:A3,1.1) = NAN

Related Videos

PERCENTILE

See Also

References