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.

แƒ™แƒแƒจแƒ˜

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

แƒ‘แƒ”แƒ แƒœแƒฃแƒšแƒ˜

  • SP แƒแƒ แƒ˜แƒก แƒชแƒ“แƒ˜แƒก แƒฌแƒแƒ แƒ›แƒแƒขแƒ”แƒ‘แƒ˜แƒก แƒแƒšแƒ‘แƒแƒ—แƒแƒ‘แƒ.

แƒ‘แƒ˜แƒœแƒแƒ›แƒฃแƒ แƒ˜

  • SP แƒแƒ แƒ˜แƒก แƒชแƒ“แƒ˜แƒก แƒฌแƒแƒ แƒ›แƒแƒขแƒ”แƒ‘แƒ˜แƒก แƒแƒšแƒ‘แƒแƒ—แƒแƒ‘แƒ.

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

แƒฎแƒ˜-แƒ™แƒ•แƒแƒ“แƒ แƒแƒขแƒ˜

  • Nu Value: a positive integer that specifies the number of degrees of freedom.

แƒ’แƒ”แƒแƒ›แƒ”แƒขแƒ แƒ˜แƒฃแƒšแƒ˜

  • SP แƒแƒ แƒ˜แƒก แƒชแƒ“แƒ˜แƒก แƒฌแƒแƒ แƒ›แƒแƒขแƒ”แƒ‘แƒ˜แƒก แƒแƒšแƒ‘แƒแƒ—แƒแƒ‘แƒ.

แƒฃแƒแƒ แƒงแƒแƒคแƒ˜แƒ—แƒ˜ แƒ‘แƒ˜แƒœแƒแƒ›แƒฃแƒ แƒ˜

  • SP แƒแƒ แƒ˜แƒก แƒชแƒ“แƒ˜แƒก แƒฌแƒแƒ แƒ›แƒแƒขแƒ”แƒ‘แƒ˜แƒก แƒแƒšแƒ‘แƒแƒ—แƒแƒ‘แƒ.

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

แƒžแƒฃแƒแƒกแƒแƒœแƒ˜

  • Mean: The mean of the Poisson distribution.

แƒžแƒแƒ แƒแƒ›แƒ”แƒขแƒ แƒ”แƒ‘แƒ˜

แƒ›แƒแƒ›แƒฎแƒ›แƒแƒ แƒ”แƒ‘แƒšแƒ˜แƒก แƒ›แƒœแƒ˜แƒจแƒ•แƒœแƒ”แƒšแƒแƒ‘แƒ˜แƒก แƒฉแƒแƒ แƒ—แƒ•แƒ

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.

แƒ“แƒแƒ›แƒ แƒ’แƒ•แƒแƒšแƒ”แƒ‘แƒ˜แƒก แƒฉแƒแƒ แƒ—แƒ•แƒ

Round the number to a given number of Decimal Places.

แƒแƒ—แƒฌแƒ˜แƒšแƒแƒ“แƒ—แƒ แƒแƒ“แƒ’แƒ˜แƒšแƒ˜

Number of decimal places of the numbers generated.

Please support us!