Difference between revisions of "Manuals/calci/PERCENTILE"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">''' PERCENTILE(ar,k) '''</div><br/> | <div style="font-size:30px">''' PERCENTILE(ar,k) '''</div><br/> | ||
| − | *<math>ar</math> is the array of data | + | *<math>ar</math> is the array of data . |
| − | *<math> k </math> is the Percentile | + | *<math> k </math> is the Percentile value. |
==Description== | ==Description== | ||
| Line 10: | Line 10: | ||
*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). | *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 general, percentiles and quartiles are specific types of quantiles. | ||
| − | *In <math>PERCENTILE(ar,k), ar </math> is the array of data that indicating relative standing and <math>k </math> is the Percentile value in the range 0..1(inclusive). | + | *In <math>PERCENTILE(ar,k), ar </math> is the array of data that indicating relative standing and <math>k </math> is the Percentile value in the range 0...1(inclusive). |
*This function will return the result as error when | *This function will return the result as error when | ||
1. The array value is empty. | 1. The array value is empty. | ||
| Line 40: | Line 40: | ||
==References== | ==References== | ||
| − | * [ http://en.wikipedia.org/wiki/Percentile Percentile ] | + | * [http://en.wikipedia.org/wiki/Percentile Percentile ] |
Revision as of 00:59, 6 January 2014
PERCENTILE(ar,k)
- is the array of data .
- is the Percentile value.
is the array of data .
is the Percentile value.Description
- This function gives the k-th 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 the 25th 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 0...1(inclusive).
- This function will return the result as error when
is the array of data that indicating relative standing and 1. The array value is empty. 2. k is nonnumeric or k<0 or k>1.
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