From c124f21d9c10bd56bfe8c1b1e89a898c360372a0 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Sat, 23 Aug 2014 17:22:38 -0300 Subject: FDO#80453 Help page for Edit-Fill-Random Numbers Help page for Calc's Edit - Fill - Random numbers Change-Id: Iab6c86f77d5bdc170af2e6cdf208470b0ce1db9f Reviewed-on: https://gerrit.libreoffice.org/11097 Reviewed-by: Joren De Cuyper Tested-by: Joren De Cuyper --- AllLangHelp_scalc.mk | 1 + source/text/scalc/01/02140700.xhp | 219 ++++++++++++++++++++++++++++++++++++++ 2 files changed, 220 insertions(+) create mode 100644 source/text/scalc/01/02140700.xhp diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 69ba36e4a3..b20a026324 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -36,6 +36,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/02140400 \ helpcontent2/source/text/scalc/01/02140500 \ helpcontent2/source/text/scalc/01/02140600 \ + helpcontent2/source/text/scalc/01/02140700 \ helpcontent2/source/text/scalc/01/02150000 \ helpcontent2/source/text/scalc/01/02160000 \ helpcontent2/source/text/scalc/01/02170000 \ diff --git a/source/text/scalc/01/02140700.xhp b/source/text/scalc/01/02140700.xhp new file mode 100644 index 0000000000..fff36fbf91 --- /dev/null +++ b/source/text/scalc/01/02140700.xhp @@ -0,0 +1,219 @@ + + + + + + +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 + +
+Menu Edit – Fill – Random Numbers +
+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 are + + +Uniform + + +Uniform Integer + + +Normal + + +Cauchy + + +Bernoulli + + +Binomial + + +Chi Squared + + +Geometric + + +Negative Binomial + +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. +Parameters +Depending on the selected distribution, the parameters describe properties for the number generators. The table below summarizes the parameters of each distribution: + + + +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. + + + +
+ +
+For more information on the distributions, see the Wikipedia +
+ + \ No newline at end of file -- cgit v1.2.3