Fill Random Numbers
text/scalc/01/02140700.xhp
Fill Random Numbers
Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters.
fill range;random numbers
random rumbers;fill range
random rumbers;distribution
Menu - Edit – Fill – Random Numbers
Data
Cell Range
Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here.
Random number generator
Distribution
The distribution function for the random number generator.
Valid distributions function and their parameters are
Distribution
Parameters
Uniform
Minimum: The minimum value of the sample.
Maximum: The maximum value of the sample.
Uniform Integer
Minimum: The minimum value of the sample.
Maximum: The maximum value of the sample.
Normal
Mean: The mean of the Normal distribution.
Standard Deviation: The standard deviation of the Normal distribution.
The mean and standard deviation of the numbers generated may not equal the Mean and Standard Deviation inserted in the dialog.
Cauchy
Median: the median of the data or location parameter.
Sigma: the scale parameter.
The median and sigma of the generated numbers may not equal the data inserted in the dialog.
Bernoulli
p Value: The probability of success.
Binomial
p Value: The probability of success of each trial.
Number of trials: the number of trials of the experiment.
Chi Squared
Nu Value: a positive integer that specifies the number of degrees of freedom.
Geometric
p Value: The probability of success of each trial.
Negative Binomial
p Value: The probability of success of each trial.
Number of trials: the number of trials of the experiment.
Options
Enable custom seed
Set the initial value of the random number generator to a known value Seed.
Seed
Value set to initiate the random number generator algorithm. It is used to initialize (seed) the random number generator in order to reproduce the same sequence of pseudorandom numbers. Specify a positive integer number (1, 2, ...) to produce a specific sequence, or leave the field blank if you don't need this particular feature.
Enable rounding
Truncate the number to a given number of Decimal Places.
Decimal places
Number of decimal places of the numbers generated.