From 267c6f2ac71f92999e969232431ba04678e7437e Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Mon, 15 Apr 2024 07:54:39 +0200 Subject: Adding upstream version 4:24.2.0. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/01/02140700.xhp | 208 +++++++++++++++++++++++++ 1 file changed, 208 insertions(+) create mode 100644 helpcontent2/source/text/scalc/01/02140700.xhp (limited to 'helpcontent2/source/text/scalc/01/02140700.xhp') diff --git a/helpcontent2/source/text/scalc/01/02140700.xhp b/helpcontent2/source/text/scalc/01/02140700.xhp new file mode 100644 index 0000000000..982aa25fa9 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/02140700.xhp @@ -0,0 +1,208 @@ + + + + + + +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 + +

+ +

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. + + + + + +Poisson + + + + +Mean: The mean of the Poisson distribution. + + + +

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

+ +Round the number to a given number of Decimal Places. +

Decimal places

+ +Number of decimal places of the numbers generated. + + -- cgit v1.2.3