Skip to main content

Questions concerning the RANDOM function

  • February 15, 2013
  • 0 replies
  • 0 views

Problem:

Need a way of obtaining a random sample from approximately 960,000 claim numbers. Can the RANDOM function be used for this task.

Resolution:

The RANDOM function is not really geared towards such a task.

The RANDOM function will generate a unique sequence of RANDOM numbers given a seed value argument.

The return value from the function will be a floating point COMP-2 number with a value greater than 0 and less than one so it will always be a fractional number and can sometimes be negative.

If this function is used to generate a specific range of numbers then the result should be multiplied by a constant value and the result should be checked that it falls within the specified range.

Old KB# 4447