From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/01/02140700.xhp | 194 +++++++++++++++++++++++++ 1 file changed, 194 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 000000000..bc5a8f191 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/02140700.xhp @@ -0,0 +1,194 @@ + + + + + + +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 + +
+Choose Sheet - Fill Cells - Random Number +
+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. + + + +
+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 + +Truncate the number to a given number of Decimal Places. +Decimal places + +Number of decimal places of the numbers generated. + + -- cgit v1.2.3