# Difference between revisions of "Manuals/calci/RANKS"

Jump to navigation
Jump to search

(7 intermediate revisions by 2 users not shown) | |||

Line 17: | Line 17: | ||

==Examples== | ==Examples== | ||

− | + | 1.RANKS([32,67,12,10,23],3,0) | |

{| class="wikitable" | {| class="wikitable" | ||

|- | |- | ||

Line 30: | Line 30: | ||

|67 || 1 ||4 | |67 || 1 ||4 | ||

|} | |} | ||

+ | 2.RANKS([100,32.2,54.01,210.3,32,45,54.01,76,10.002],4,5) | ||

+ | {| class="wikitable" | ||

+ | |- | ||

+ | |10.002 || 1 || 5 | ||

+ | |- | ||

+ | |32 || 1 || 6 | ||

+ | |- | ||

+ | |32.2 || 1 || 7 | ||

+ | |- | ||

+ | |45 || 1 || 8 | ||

+ | |- | ||

+ | |54.01 || 2 ||9.5 | ||

+ | |- | ||

+ | |76 || 1 || 11 | ||

+ | |- | ||

+ | |100 || 1 || 12 | ||

+ | |- | ||

+ | |210.3 || 1 ||13 | ||

+ | |} | ||

+ | |||

+ | |||

+ | ==Related Videos== | ||

+ | |||

+ | {{#ev:youtube|v=Pu32MJHL2nw|280|center|Ranks}} | ||

+ | |||

+ | ==See Also== | ||

+ | *[[Manuals/calci/RANK | RANK ]] | ||

+ | *[[Manuals/calci/RANKANDPERCENTILE | RANKANDPERCENTILE]] | ||

+ | *[[Manuals/calci/PERCENTRANK | PERCENTRANK ]] | ||

+ | |||

+ | ==References== | ||

+ | [http://stattrek.com/matrix-algebra/matrix-rank.aspx Rank] | ||

+ | |||

+ | |||

+ | |||

+ | *[[Z_API_Functions | List of Main Z Functions]] | ||

+ | |||

+ | *[[ Z3 | Z3 home ]] |

## Latest revision as of 16:10, 30 November 2018

**RANKS(r,n,o)**

- is the set of numbers.
- is the number to get ranked.
- is the number to start.

## Description

- This function gives the ranks of a each number in given set of numbers.
- It is based on the value of a number, relative to the other numbers in the list.
- In RANK(r,n,o), is the range of the cells to find the ranking the number and o indicates the number is ranked in ascending or descending order.
- is the number to be get ranked.
- If o is zero, then the list of the numbers getting in descending order.
- If o is 1, then the list of the numbers getting in ascending order.
- When we are not mentioning the o value, then it will give the set of numbers in descending order.
- RANKS 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 non-numeric.

## Examples

1.RANKS([32,67,12,10,23],3,0)

10 | 1 | 0 |

12 | 1 | 1 |

23 | 1 | 2 |

32 | 1 | 3 |

67 | 1 | 4 |

2.RANKS([100,32.2,54.01,210.3,32,45,54.01,76,10.002],4,5)

10.002 | 1 | 5 |

32 | 1 | 6 |

32.2 | 1 | 7 |

45 | 1 | 8 |

54.01 | 2 | 9.5 |

76 | 1 | 11 |

100 | 1 | 12 |

210.3 | 1 | 13 |

## Related Videos

## See Also

## References