Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
RAND( ) [Category: Math]
Returns an evenly distributed random number greater than or equal to 0 and
less than 1. A new random number is returned every time the worksheet is
calculated. Guru Tip: To generate random numbers between 1 and 10, use
=INT(RAND()*10)+1
RANDBETWEEN(bottom,top) [Category: Math]*
Returns a random number between the numbers you specify. A new random
number is returned every time the worksheet is calculated. Guru Tip: Unlike
RAND, this function returns integers. When I need to add some "noise" to data,
I will add =RAND(-3,3) to subtract/add anywhere from 1 to 3 to each number in
a range. If you want to select random items from a list, the RANDBETWEEN() is
a perfect argument for INDEX: =INDEX(J1:J30,RANDBETWEEN(1,30)).
RANK(number,ref,order) [Category: Statistical]]
Returns the rank of a number in a list of numbers. The rank of a number is its
size relative to other values in a list. (If you were to sort the list, the rank of the
number would be its position.) Guru Tip: most people leave off the 3rd argument
which means that the highest value receives a rank of 1. However, if you are
ranking golf scores, put any non-zero value as the 3rd argument. Then the
lowest score receives a rank of 1.
Rank deals with ties in the same way that the sporting pages would. In the
example below, two scores are tied for second. Both of these scores receive a
2 and none of the scores receive a 3. The next score receives a 4. Similar ties
at 5th and 7th mean that no one is ranked 6th or 8th.
 
Search JabSto ::




Custom Search