3
Label all the items of your targeted population sequentially with a number. If
you are to select 200 samples from this population, then you should
randomly select a starting point on the table, move down columns selecting
appropriate numbers which have their last three digits being less than 200
until you attain 200 samples.
b. Generation of random numbers from MS Excel spreadsheet
Again label your population items sequentially, identify each item with a
random number generated by the MS Excel RAND() function, and then rank
the random numbers in ascending order by Excel function RANK(). Pick up
the number of samples targeted according to their ranking order. Figure 2
shows an example of 12 items in a population randomized and ranked.Fi
Figure 2: Randomization and ranking of 12 items in a population
A B C
1 Item # Random Rank
2 A(1) =RAND() =RANK(B2,$B2:B13,1)
3 A(2) =RAND() =RANK(B3,$B2:B13,1)
4 A(3) =RAND() =RANK(B4,$B2:B13,1)
~~ ~~ ~~ ~~
11 A(10) =RAND() =RANK(B11,$B2:B13,1)
12 A(11) =RAND() =RANK(B12,$B2:B13,1)
13 A(12) =RAND() =RANK(B13,$B2:B13,1)
c. Use of statistical software such as R programming
Those who are familiar with the open source statistical software R will find
selecting random samples very easily. For example, after labelling all the
100 items of a population sequentially, we write in the R program:
> C=sample(100,10) #Randomly take 10 samples from 100 in a population
> C
[1] 19 57 27 60 11 86 50 36 29 9