Fill Random Numbers

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

Selle kÀsu kasutamiseks...

Choose Sheet - Fill Cells - Random Number


Andmed

Lahtrivahemik

Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here.

Juhuarvude generaator

Jaotus

Tagastab standardiseeritud normaaljaotuse jaotusfunktsiooni vÀÀrtused.

Valid distributions function and their parameters are

Jaotus

Parameetrid

Ühtlane

  • Keskmine on jaotuse keskmine vÀÀrtus.

  • NimivÀÀrtus on vÀÀrtpaberi nimivÀÀrtus.

Ühtlane (tĂ€isarvud)

  • Keskmine on jaotuse keskmine vÀÀrtus.

  • NimivÀÀrtus on vÀÀrtpaberi nimivÀÀrtus.

Normaaljaotus

  • Keskmine on jaotuse keskmine vÀÀrtus.

  • StandardhĂ€lve: normaaljaotuse standardhĂ€lve.

Hoiatav ikoon

The mean and standard deviation of the numbers generated may not equal the Mean and Standard Deviation inserted in the dialog.


Cauchy

  • Keskmine on jaotuse keskmine vÀÀrtus.

  • Lambda on parameetri vÀÀrtus.

Hoiatav ikoon

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


Bernoulli

  • SP on iga katse edu tĂ”enĂ€osus.

Binoomjaotus

  • SP on iga katse edu tĂ”enĂ€osus.

  • Arv on korduste arv.

Hii-ruut

  • Arv mÀÀrab mĂ€rkide arvu teksti osas.

Geomeetriline

  • SP on iga katse edu tĂ”enĂ€osus.

Negatiivne binoomjaotus

  • SP on iga katse edu tĂ”enĂ€osus.

  • Arv on korduste arv.


SĂ€tted

Kohandatud seeme

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

Seeme

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.

Ümardatakse

Truncate the number to a given number of Decimal Places.

KĂŒmnendkohti

Number of decimal places of the numbers generated.

Palun toeta meid!