Fill Random Numbers

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

β€‹β€‹αžŠαžΎαž˜αŸ’αž”αžΈβ€‹αž”αŸ’αžšαžΎβ€‹β€‹αž”αž‰αŸ’αž‡αžΆβ€‹αž“αŸαŸ‡...

From the menu bar:

Choose Sheet - Fill Cells - Fill Random Number


αž‘αž·αž“αŸ’αž“αž“αŸαž™

αž‡αž½αžšβ€‹αž€αŸ’αžšαž‘αžΆ

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

αž€αžΆαžšβ€‹αž…αŸ‚αž€αž…αžΆαž™

The distribution function for the random number generator.

Valid distributions function and their parameters are

αž€αžΆαžšβ€‹αž…αŸ‚αž€αž…αžΆαž™

αž”αŸ‰αžΆαžšαŸ‰αžΆαž˜αŸ‰αŸ‚αžαŸ’αžš

αž˜αž·αž“β€‹αžŠαžΌαž…αž‚αŸ’αž“αžΆ

  • Minimum: The minimum value of the sample.

  • Maximum: The maximum value of the sample.

αž…αŸ†αž“αž½αž“β€‹αž‚αžαŸ‹β€‹αž˜αž·αž“β€‹αžŠαžΌαž…αž‚αŸ’αž“αžΆ

  • Minimum: The minimum value of the sample.

  • Maximum: The maximum value of the sample.

αž’αž˜αŸ’αž˜αžαžΆ

  • Mean: The mean of the Normal distribution.

  • Standard Deviation: The standard deviation of the Normal distribution.

warning

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.

warning

The median and sigma of the generated numbers may not equal the data inserted in the dialog.


Bernoulli

  • SP αž‡αžΆβ€‹αž”αŸ’αžšαžΌαž”αžΆαž”αŸŠαžΈαž›αžΈαžαŸβ€‹αž“αŸƒβ€‹αž‡αŸ„αž‚αž‡αŸαž™β€‹αž›αžΎβ€‹αž€αžΆαžšβ€‹αžŸαžΆαž€αž›αŸ’αž”αž„β€‹αž“αžΈαž˜αž½αž™αŸ—Β αŸ”

Binomial

  • SP αž‡αžΆβ€‹αž”αŸ’αžšαžΌαž”αžΆαž”αŸŠαžΈαž›αžΈαžαŸβ€‹αž“αŸƒβ€‹αž‡αŸ„αž‚αž‡αŸαž™β€‹αž›αžΎβ€‹αž€αžΆαžšβ€‹αžŸαžΆαž€αž›αŸ’αž”αž„β€‹αž“αžΈαž˜αž½αž™αŸ—Β αŸ”

  • 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.

αžšαŸαžαžΆβ€‹αž‚αžŽαž·αž

  • SP αž‡αžΆβ€‹αž”αŸ’αžšαžΌαž”αžΆαž”αŸŠαžΈαž›αžΈαžαŸβ€‹αž“αŸƒβ€‹αž‡αŸ„αž‚αž‡αŸαž™β€‹αž›αžΎβ€‹αž€αžΆαžšβ€‹αžŸαžΆαž€αž›αŸ’αž”αž„β€‹αž“αžΈαž˜αž½αž™αŸ—Β αŸ”

Binomial αžœαž·αž‡αŸ’αž‡αž˜αžΆαž“

  • SP αž‡αžΆβ€‹αž”αŸ’αžšαžΌαž”αžΆαž”αŸŠαžΈαž›αžΈαžαŸβ€‹αž“αŸƒβ€‹αž‡αŸ„αž‚αž‡αŸαž™β€‹αž›αžΎβ€‹αž€αžΆαžšβ€‹αžŸαžΆαž€αž›αŸ’αž”αž„β€‹αž“αžΈαž˜αž½αž™αŸ—Β αŸ”

  • Number of trials: the number of trials of the experiment.

Poisson

  • Mean: The mean of the Poisson distribution.


αž‡αž˜αŸ’αžšαžΎαžŸ

Enable custom seed

Set the initial value of the random number generator to a known value 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

Round the number to a given number of Decimal Places.

αžαŸ’αž‘αž„αŸ‹β€‹αž‘αžŸαž—αžΆαž‚

Number of decimal places of the numbers generated.

Please support us!