ZCubes Wiki

Difference between revisions of "Manuals/calci/PERCENTILE"

(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''PERCENTILE'''(Array, k) where, '''Array''' - is the set of data. '''k''' - represents the percentile in...")
 
 
(12 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">''' PERCENTILE (Array,kth) '''</div><br/>
 +
*<math>Array</math>  is the array of data .
 +
*<math>kth </math> is the Percentile value.
 +
**PERCENTILE(),returns the k-th percentile of values in a range.
  
−
'''PERCENTILE'''(Array, k)
+
==Description==
 +
*This function gives the <math>k^{th}</math> 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 <math>25^{th}</math> 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 <math>PERCENTILE(Array,kth)</math>,  <math>Array</math>  is the array of data that indicating relative standing and <math>kth </math> is the Percentile value in the range <math>0...1</math>(inclusive).
 +
*This function will return the result as error when
 +
1. The array value is empty.
 +
2. <math>k</math> is non-numeric or <math>k < 0</math> or <math> k > 1</math>.
  
−
where,
+
==Examples==
 +
1.
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C !! D
 +
|-
 +
! 1
 +
| 5 || 7 || 2 || 9
 +
|}
 +
=PERCENTILE(A1:D1,0.4) = 5.4
 +
2.
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C !! D !! E
 +
|-
 +
! 1
 +
| 15 || 20 || 12 || 41 ||35
 +
|}
 +
=PERCENTILE(A1:E1,0.721) = 33.26
  
−
'''Array''' - is the set of data.
+
3.
−
 
+
{| class="wikitable"
−
'''k''' - represents the percentile in between 0 and 1 inclusive.
+
|+Spreadsheet
−
 
+
|-
−
</div>
+
! !! A !! B !! C
−
----
+
|-
−
<div id="1SpaceContent" class="zcontent" align="left">Returns thethe k-th percentile of value from set of data.</div>
+
! 1
−
----
+
| 2 || 3 || 4
−
<div id="7SpaceContent" class="zcontent" align="left">
+
|}
−
 
+
=PERCENTILE(A1:A3,1.1) = NAN
−
If k is nonnumeric, PERCENTILE returns #ERROR.
 
−
 
 
−
If k&lt; 0 or k &gt; 1, it returns #ERROR.
 
  
−
</div>
+
==Related Videos==
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
PERCENTILE
+
{{#ev:youtube|g76wlb_7HSk|280|center|PERCENTILE}}
  
−
</div></div>
+
==See Also==
−
----
+
*[[Manuals/calci/MAX  | MAX ]]
−
<div id="8SpaceContent" class="zcontent" align="left">
+
*[[Manuals/calci/MIN  | MIN ]]
 +
*[[Manuals/calci/MEDIAN  | MEDIAN]]
 +
*[[Manuals/calci/QUARTILE  | QUARTILE ]]
  
−
Lets see an example in (Column1, Row5)
+
==References==
  
−
<nowiki>=PERCENTILE(R1C1:R4C1,0.8)</nowiki>
+
* [http://en.wikipedia.org/wiki/Percentile Percentile  ]
  
−
PERCENTILE returns 80-th of given array is 15.8.
 
  
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
  
−
{| id="TABLE3" class="SpreadSheet blue"
+
*[[Z_API_Functions | List of Main Z Functions]]
−
|- class="even"
 
−
| class=" " |
 
−
| class="  " | Column1
 
−
| Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class=" " | 11
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class=" " | 23
 
−
|
 
−
|
 
−
|
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f" | 1
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| Row4
 
−
| class="    " | 5
 
−
|
 
−
|
 
−
|
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f" | 15.8
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| Row6
 
−
| class="    SelectTD ChangeBGColor SelectTD" |
 
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
 
−
|
 
−
|
 
−
|
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 15:46, 8 August 2018

PERCENTILE (Array,kth)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the array of data .
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle kth } is the Percentile value.
    • PERCENTILE(),returns the k-th percentile of values in a range.

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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 25^{th}} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PERCENTILE(Array,kth)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the array of data that indicating relative standing and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle kth } is the Percentile value in the range Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 0...1} (inclusive).
  • This function will return the result as error when
1. The array value is empty.
2. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle k}
 is non-numeric or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle k < 0}
 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


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/PERCENTILE&oldid=210962"