Random testing of workers for drugs of abuse may be part of an occupational drug testing program. This is often done by using a random number generator to select the workers who will be tested.
NOTE: See also 32.15.35
In Excel the random number function is RAND(), which generates random a decimal fraction from 0 to 1.
A random number in the range of x to y is selected as:
random number =
= (RAND() * (y -x)) + x
Issues in random testing:
(1) A company must be able to show that the selection process is truly random.
(2) All employees who are subject to the provisions of drug testing must be entered into the testing pool.
(3) Any employee who has been tested must be added back to the pool for the next selection.
Implementation requirements:
(1) There should be a separate file assigning each employee at risk to a specific number.
(2) The formula bar should be in view. To generate another list of random numbers, put the cursor into the formula bar and hit "Enter".
To read more or access our algorithms and calculators, please log in or register.
