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="...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''QUARTILE(ar,qu)'''</div><br/>
 +
*<math>ar</math>  is the array of numeric values
 +
*<math> qu</math> indicates the  position of the quartile
  
<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>
 
  
<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>
+
==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(ar,qu), ar</math> is the array  of numeric values to find the Quartile and <math> qu</math> is the position of the quartile.
 +
*qu value        QUARTILE(result)
 +
0  _                  Minimum value
 +
-                 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 interquartile range.
 +
*When we are giving qu 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. qu<0 or qu>4
 +
  3. MIN,MEDIAN and MAX will give the same value as QUARTILE when qu is 0,2,and 4 respectively.
  
<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>
 
  
<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>
+
==Examples==
 +
#ar={2,3,7,9,15}
 +
*QUARTILE(A1:A5,0)=2
 +
*QUARTILE(A1:A5,1)=3
 +
#ar={8,12,13,20,25,28,42}
 +
*QUARTILE(B2:B8,3)=26.5
 +
*QUARTILE(B2:B8,4)=42
 +
*QUARTILE(B2:B8,5)=NAN
  
<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>
+
==See Also==
 +
*[[Manuals/calci/MAX  | MAX ]]
 +
*[[Manuals/calci/MIN  | MIN ]]
 +
*[[Manuals/calci/MEDIAN  | MEDIAN ]]
 +
*[[Manuals/calci/PERCNTILE  |PERCNTILE ]]
  
<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>
+
==References==
 
 
<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>
 
 
 
</div>
 
----
 
<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>
 
 
 
</div>
 
----
 
<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>
 
----
 
<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>
 
----
 

Revision as of 03:58, 6 January 2014

QUARTILE(ar,qu)


  • is the array of numeric values
  • indicates the position of the quartile


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 interquartile range.
  • When we are giving qu 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. qu<0 or qu>4
 3. MIN,MEDIAN and MAX will give the same value as QUARTILE when qu is 0,2,and 4 respectively.


Examples

  1. ar={2,3,7,9,15}
  • QUARTILE(A1:A5,0)=2
  • QUARTILE(A1:A5,1)=3
  1. ar={8,12,13,20,25,28,42}
  • QUARTILE(B2:B8,3)=26.5
  • QUARTILE(B2:B8,4)=42
  • QUARTILE(B2:B8,5)=NAN

See Also

References