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 03:15, 15 January 2014

RANK(n,r,o)


  • 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 n} is the number to be ranked.
  • 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 r} is the range of numbers .
  • 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 o} 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, 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 r} is the range of the cells to find the ranking the number 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 o} indicates the number is ranked in ascending or descending order.
  • If 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 o} is zero, then the list of the numbers getting in descending order.
  • If 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 o} is 1, then the list of the numbers getting in ascending order.
  • When we are not mentioning 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 o} value, then it will give the set of numbers in descending order.
  • 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 RANK} 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
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/RANK&oldid=197237"