Difference between revisions of "Manuals/calci/RANK"

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">'''RANK'''</font></font><font face="Arial, sans-serif"><font size="2">(</...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left"> <font face="Arial, sans-serif"><font size="2">'''RANK'''</font></font><font face="Arial, sans-serif"><font size="2">(</font></font><font face="Arial, sans-serif"><font size="2">'''num'''</font></font><font face="Arial, sans-serif"><font size="2">,</font></font><font face="Arial, sans-serif"><font size="2">'''r'''</font></font><font face="Arial, sans-serif"><font size="2">,od)</font></font>
+
<div style="font-size:30px">'''RANK(n,r,o)'''</div><br/>
 +
*<math>n</math> is the number to be ranked.
 +
*<math>r</math> is the range of numbers .
 +
*<math> o</math> indicates the number is ranked in ascending or descending order.
 +
  
<font face="Arial, sans-serif"><font size="2">'''Where num '''</font></font><font face="Arial, sans-serif"><font size="2">  is the number for which rank to be find and r   is a list of numbers and od is a number specifying how to rank number.</font></font>
+
==Description==
 +
*This function gives the rank of a given set of numbers.
 +
*It is based on the value of a number, relative to the other numbers in the list.
 +
*In <math> RANK(n,r,o), n</math> is the number to be get ranked, <math>r</math> is the range of the cells to find the ranking the number and <math>o</math> indicates the number is ranked in ascending or descending order.
 +
*If <math>o</math> is zero, then the list of the numbers getting in descending order.
 +
*If <math>o</math> is 1, then  the list of the numbers getting in ascending order.  
 +
*When we are not mentioning the <math>o</math>  value, then it will give the set of numbers in descending order.
 +
*<math>RANK</math> gives the spare numbers that having the same rank.
 +
*The occurrence of the spare number affects the ranks of the next numbers.
 +
*This function will return the result as error when any one of the argument is nonnumeric.
  
</div>
 
----
 
<div id="1SpaceContent" class="zcontent" align="left"> <font face="Arial, sans-serif"><font size="2">It calculates the rank of a number in a list of numbers. The rank of a number means its size relative to other values in a list.</font></font></div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
RANK
+
==Examples==
 
+
1. Number={20,7,5,17,32}
</div></div>
+
RANK(7,C1:C5,0)=4
----
+
RANK(7,C1:C5,1)=2
<div id="8SpaceContent" class="zcontent" align="left"> 
+
2. Number={10,4,-1,0,15,24,45}
 
+
RANK(4,G1:G7,0)=5
<font color="#000000"><font face="Times New Roman, serif"><font size="3">Let’s see an example in (Column1 Row 1:Column1Row5)</font></font></font>
+
RANK(4,G1:G7,1)=3
 
+
RANK(-1,G1:G7,0)=7
<font color="#000000"><font face="Times New Roman, serif"><font size="3">RANK (num,r,od)</font></font></font>
+
3. Number={4,-1,-47,-23,0,-18,1,-35}
 
+
RANK(0,H1:H8,0)=3
<font color="#00007f"><font face="Courier New, monospace"><font size="3">i.e. =RANK (C1R5,C1R1:C1R5, 1) is 4</font></font></font>
+
RANK(0,H1:H8,1)=6
 
+
RANK(-18,H1:H8,1)=4
</div>
+
{| class="wikitable"
----
+
|+Spreadsheet
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
+
|-
----
+
! !! A !! B !! C !!D !! E !! F !! G !! H
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
+
|-
----
+
! 1
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
+
|20 || 7 || 5 || 17 || 32 
----
+
|-
<div id="2SpaceContent" class="zcontent" align="left">
+
! 2
 
+
| 10 || 4 || -1 || 0 || 15 || 24 || 45
{| id="TABLE3" class="SpreadSheet blue"
+
|-
|- class="even"
+
!3
| class=" " |
+
| 4 || -1 || -47 || -23 || 0 || -18 || 1 || -35
| class="  " | Column1
 
| class="      " | Column2
 
| Column3
 
| Column4
 
|- class="odd"
 
| class=" " | Row1
 
| class="  " | 8
 
| class="sshl_f" | 4
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="even"
 
| class="  " | Row2
 
| class="sshl_f" | 5.5
 
| class="sshl_f SelectTD SelectTD" |
 
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
|
 
|
 
|- class="odd"
 
| Row3
 
| class="sshl_f" | 5.5
 
|
 
|
 
|
 
|- class="even"
 
| Row4
 
| class="sshl_f" | 3
 
|
 
|
 
| class="  " |
 
|- class="odd"
 
| class=" " | Row5
 
| class=" " | 6
 
|
 
|
 
|
 
|- class="even"
 
| class="sshl_f" | Row6
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="odd"
 
| class="sshl_f  " | Row7
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="even"
 
| class="sshl_f" | Row8
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="odd"
 
| class="sshl_f" | Row9
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="even"
 
| class="sshl_f" | Row10
 
| class="sshl_f" |
 
|
 
|
 
|
 
 
|}
 
|}
 
<div align="left">[[Image:calci1.gif]]</div></div>
 
----
 

Revision as of 04:15, 15 January 2014

RANK(n,r,o)


  • is the number to be ranked.
  • is the range of numbers .
  • indicates the number is ranked in ascending or descending order.


Description

  • This function gives the rank of a given set of numbers.
  • It is based on the value of a number, relative to the other numbers in the list.
  • In is the number to be get ranked, is the range of the cells to find the ranking the number and indicates the number is ranked in ascending or descending order.
  • If is zero, then the list of the numbers getting in descending order.
  • If is 1, then the list of the numbers getting in ascending order.
  • When we are not mentioning the value, then it will give the set of numbers in descending order.
  • gives the spare numbers that having the same rank.
  • The occurrence of the spare number affects the ranks of the next numbers.
  • This function will return the result as error when any one of the argument is nonnumeric.


Examples

1. Number={20,7,5,17,32} RANK(7,C1:C5,0)=4 RANK(7,C1:C5,1)=2 2. Number={10,4,-1,0,15,24,45} RANK(4,G1:G7,0)=5 RANK(4,G1:G7,1)=3 RANK(-1,G1:G7,0)=7 3. Number={4,-1,-47,-23,0,-18,1,-35} RANK(0,H1:H8,0)=3 RANK(0,H1:H8,1)=6 RANK(-18,H1:H8,1)=4

Spreadsheet
A B C D E F G H
1 20 7 5 17 32
2 10 4 -1 0 15 24 45
3 4 -1 -47 -23 0 -18 1 -35