Fill Random Numbers

Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters.

P'aportar a esta orde...

Dende la barra de menús:

Choose Sheet - Fill Cells - Fill Random Number

Datos

Área de caxelles

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

Distribución

The distribution function for the random number generator.

Valid distributions function and their parameters are

Distribución	Parámetros
Uniforme	Minimum: The minimum value of the sample. Maximum: The maximum value of the sample.
Enteru uniforme	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	prob_ésitu ye la probabilidá d'ésitu de cada intentu.
Binomial	prob_ésitu ye la probabilidá d'ésitu de cada intentu. Number of trials: the number of trials of the experiment.
Chi al cuadráu	Nu Value: a positive integer that specifies the number of degrees of freedom.
Xeométrica	prob_ésitu ye la probabilidá d'ésitu de cada intentu.
Binomial negativa	prob_ésitu ye la probabilidá d'ésitu de cada intentu. Number of trials: the number of trials of the experiment.
Poisson	Mean: The mean of the Poisson distribution.

Opciones

Enable custom seed

Set the initial value of the random number generator to a known value Seed.

Velocidá

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

Round the number to a given number of Decimal Places.

Decimales

Number of decimal places of the numbers generated.