Difference between revisions of "Manuals/calci/QUARTILE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font face="Arial, sans-serif"><font size="2">'''QUARTILE'''</font></font><font face="Arial, sans-serif"><font size="...")
 
 
(15 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''QUARTILE(Array,Quartile)'''</div><br/>
 +
*<math>Array</math>  is the array of numeric values
 +
*<math>Quartile</math> indicates the  position of the quartile
 +
**QUARTILE(), returns the quartile of a data set.
  
−
<font face="Arial, sans-serif"><font size="2">'''QUARTILE'''</font></font><font face="Arial, sans-serif"><font size="2">(</font></font><font face="Arial, sans-serif"><font size="2">'''arr'''</font></font><font face="Arial, sans-serif"><font size="2">,</font></font><font face="Arial, sans-serif"><font size="2">'''q'''</font></font><font face="Arial, sans-serif"><font size="2">)</font></font>
+
==Description==
 +
*This function gives the value of quartile for a given set.
 +
*Quartiles are the values that divide a list of numbers into quarters. 
 +
*A quartile is a type of quantile.
 +
*In <math> QUARTILE(Array,Quartile)</math>, <math>Array</math> is the array  of numeric values to find the Quartile and <math> Quartile</math> is the position of the quartile.
 +
'''qu value'''  '''QUARTILE(result)'''
 +
0  -          Minimum value
 +
1  -          First quartile(25th Percentile)
 +
2    -          Median value(50th Percentile)
 +
3    -          Third quartile(75th Percentile)
 +
4    -          Maximum value 
 +
*The difference between the upper and lower quartiles is called the inter-quartile range.
 +
*When we are giving <math>Quartile</math> in a decimal value, then it will change in to integer.
 +
*This function will give the result as error when
 +
  1. The array is empty
 +
  2. <math>Quartile<0</math> or <math>Quartile>4</math>
 +
  3. MIN,MEDIAN and MAX will give the same value as QUARTILE when <math>Quartile</math> is 0,2,and 4 respectively.
  
−
<font face="Arial, sans-serif"><font size="2"></font></font><font face="Arial, sans-serif"><font size="2">'''Where arr'''</font></font><font face="Arial, sans-serif"><font size="2">   is the array and q is the value to be return.</font></font>
+
==Examples==
−
 
+
{| class="wikitable"
−
<font face="Arial, sans-serif"><font size="2"></font></font><font face="Arial, sans-serif"><font size="2">If q=0,QUARTILE returns minimum value,</font></font>
+
|+Spreadsheet
−
 
+
|-
−
<font face="Arial, sans-serif"><font size="2">q=1,QUARTILE returns first quartile,i.e.25</font></font><sup><font face="Arial, sans-serif"><font size="2">th</font></font></sup><font face="Arial, sans-serif"><font size="2"> percentile,</font></font>
+
! !! A !! B !! C !! D!! E
−
 
+
|-
−
<font face="Arial, sans-serif"><font size="2"></font></font><font face="Arial, sans-serif"><font size="2">q=2,QUARTILE returns median quartile,i.e.50</font></font><sup><font face="Arial, sans-serif"><font size="2">th</font></font></sup><font face="Arial, sans-serif"><font size="2"> percentile,</font></font>
+
! 1
 +
| 2 || 3 || 7 ||9 || 15
 +
|-
 +
! 2
 +
| 8 || 12 || 13 || 20 || 25
 +
|-
 +
! 3
 +
| 14  || 3  || 9  ||6 || 15
 +
|-
 +
! 4
 +
| 12 ||23  || 1  ||42 ||17
 +
|-
 +
! 5
 +
|  ||  ||    ||  || 
 +
|}
  
−
<font face="Arial, sans-serif"><font size="2"></font></font><font face="Arial, sans-serif"><font size="2">q=3,QUARTILE returns third quartile,i.e.75</font></font><sup><font face="Arial, sans-serif"><font size="2">th</font></font></sup><font face="Arial, sans-serif"><font size="2"> percentile,</font></font>
+
*=QUARTILE(A1:A4,0) = 2
 +
*=QUARTILE(A1:A4,1) = 6.5
 +
*=QUARTILE(B2:E3,3) = 16.25
 +
*=QUARTILE(A2:B3,3) = 12.5
 +
*=QUARTILE(A5:E5,3) = NAN
  
−
<font face="Arial, sans-serif"><font size="2"></font></font><font face="Arial, sans-serif"><font size="2">q=4,QUARTILE returns maximum value</font></font>
+
==Related Videos==
  
−
</div>
+
{{#ev:youtube|g76wlb_7HSk|280|center|QUARTILE}}
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
  
−
<font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2"><font color="#000000">It calculates the quartile of a data set</font>. </font></font></font>
+
==See Also==
 +
*[[Manuals/calci/MAX  | MAX ]]
 +
*[[Manuals/calci/MIN  | MIN ]]
 +
*[[Manuals/calci/MEDIAN  | MEDIAN ]]
 +
*[[Manuals/calci/PERCENTILE  |PERCENTILE ]]
  
−
</div>
+
==References==
−
----
+
*[http://en.wikipedia.org/wiki/Quartile Quartile]
−
<div id="7SpaceContent" class="zcontent" align="left"> 
 
  
−
# <font face="Arial, sans-serif"><font size="2">If array is empty, QUARTILE displays zero. </font></font>
 
−
# <font face="Arial, sans-serif"><font size="2">QUARTILE displays error when q is less than 0 or is grater than 4. </font></font>
 
  
−
</div>
 
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
QUARTILE
 
  
−
</div></div>
+
*[[Z_API_Functions | List of Main Z Functions]]
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">  <font color="#000000"><font face="Arial, sans-serif"><font size="3">
 
−
 
 
−
<font color="#000000"><font face="Times New Roman, serif"><font size="3">i.e. =QUARTILE (C1R1:C1R8, 1) is 7.5</font></font></font>
 
−
 
 
−
</font></font></font></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"><div>
 
−
 
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| class="  " | Column1
 
−
| class="              " | Column2
 
−
| class="      " | Column3
 
−
| class="  " |
 
−
| Column4
 
−
|
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="sshl_f  " | 5
 
−
| class="sshl_f" | 7.5
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f" | 6
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f" | 8
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="  " |
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f" | 10
 
−
| class="sshl_f" |
 
−
|
 
−
| class=" " |
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="odd"
 
−
| class="sshl_f" | Row6
 
−
| class="sshl_f" | 12
 
−
| class="sshl_f" |
 
−
|
 
−
|
 
−
| class=" SelectTD SelectTD" |
 
−
|
 
−
|- class="even"
 
−
| class="sshl_f" | Row7
 
−
| class="sshl_f" | 14
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="odd"
 
−
| class="sshl_f" | Row8
 
−
| class="sshl_f" | 15
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| class="sshl_f" | Row9
 
−
| class=" " | 16
 
−
| class="sshl_f" |
 
−
|
 
−
| class=" " | 0.5253
 
−
|
 
−
|
 
−
|}
 
−
 
 
−
<div align="left"></div>''''''
 
−
 
 
−
{| class="ZCopyPasteContent"
 
−
| class="sshl_f  " |
 
−
<div id="6Space_Drag" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]</div>
 
−
|}
 
  
−
</div></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 16:00, 8 August 2018

QUARTILE(Array,Quartile)


  • is the array of numeric values
  • indicates the position of the quartile
    • QUARTILE(), returns the quartile of a data set.

Description

  • This function gives the value of quartile for a given set.
  • Quartiles are the values that divide a list of numbers into quarters.
  • A quartile is a type of quantile.
  • In , is the array of numeric values to find the Quartile and is the position of the quartile.
qu value   QUARTILE(result)
0   -           Minimum value
1   -           First quartile(25th Percentile)
2    -          Median value(50th Percentile)
3    -          Third quartile(75th Percentile)
4    -          Maximum value
  • The difference between the upper and lower quartiles is called the inter-quartile range.
  • When we are giving in a decimal value, then it will change in to integer.
  • This function will give the result as error when
 1. The array is empty
 2.  or 
 3. MIN,MEDIAN and MAX will give the same value as QUARTILE when  is 0,2,and 4 respectively.

Examples

Spreadsheet
A B C D E
1 2 3 7 9 15
2 8 12 13 20 25
3 14 3 9 6 15
4 12 23 1 42 17
5
  • =QUARTILE(A1:A4,0) = 2
  • =QUARTILE(A1:A4,1) = 6.5
  • =QUARTILE(B2:E3,3) = 16.25
  • =QUARTILE(A2:B3,3) = 12.5
  • =QUARTILE(A5:E5,3) = NAN

Related Videos

QUARTILE

See Also

References



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