summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/scalc/01/02140700.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/scalc/01/02140700.xhp')
-rw-r--r--helpcontent2/source/text/scalc/01/02140700.xhp194
1 files changed, 194 insertions, 0 deletions
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 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+<meta>
+<topic id="ID" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Fill Random Numbers</title>
+<filename>/text/scalc/01/02140700.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog" id="bm_id3150791" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/@@nowidget@@" id="bm_id3150791" localize="false"/>
+<paragraph id="hd_id2308201415431520596" role="heading" xml-lang="en-US" level="1">Fill Random Numbers</paragraph>
+<paragraph id="par_id2308201415431525817" role="paragraph" xml-lang="en-US"><ahelp hid=".">Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="index" id="bm_id2308201416102526759">
+<bookmark_value>fill range;random numbers</bookmark_value>
+<bookmark_value>random rumbers;fill range</bookmark_value>
+<bookmark_value>random rumbers;distribution</bookmark_value>
+</bookmark>
+<section id="howtoget">
+<paragraph id="par_id2308201415500176457" role="paragraph" xml-lang="en-US">Choose <item type="menuitem">Sheet - Fill Cells - Random Number</item></paragraph>
+</section>
+<paragraph id="hd_id2308201415431233475" role="heading" xml-lang="en-US" level="2">Data</paragraph>
+<paragraph id="hd_id2308201415431883475" role="heading" xml-lang="en-US" level="3">Cell Range</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/cell-range-edit" id="bm_id3150792" localize="false"/>
+<paragraph id="par_id2308201415431811111" role="paragraph" xml-lang="en-US"><ahelp hid=".">Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here.</ahelp></paragraph>
+<paragraph id="hd_id2308201415431850229" role="heading" xml-lang="en-US" level="2">Random number generator</paragraph>
+<paragraph id="hd_id2308201415431880497" role="heading" xml-lang="en-US" level="3">Distribution</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/distribution-combo" id="bm_id2308201416384294287" localize="false"/>
+<paragraph id="par_id2308201415431874867" role="paragraph" xml-lang="en-US"><ahelp hid=".">The distribution function for the random number generator.</ahelp></paragraph>
+<paragraph id="par_id2308201416441240058" role="paragraph" xml-lang="en-US">Valid distributions function and their parameters are</paragraph>
+
+
+<table id="Tabela1">
+<tablerow>
+<tablecell>
+<paragraph id="par_id230820141543181813" role="tablehead" xml-lang="en-US">Distribution</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id2308201415431868807" role="tablehead" xml-lang="en-US">Parameters</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id2308201415431869872" role="tablecontent" xml-lang="en-US">Uniform</paragraph>
+</tablecell>
+<tablecell>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id2308201415431850857" role="ul_item" xml-lang="en-US"><emph>Minimum:</emph> The minimum value of the sample.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431859422" role="ul_item" xml-lang="en-US"><emph>Maximum:</emph> The maximum value of the sample.</paragraph>
+</listitem></list>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id2308201415431848733" role="tablecontent" xml-lang="en-US">Uniform Integer</paragraph>
+</tablecell>
+<tablecell>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id2308201415431813421" role="ul_item" xml-lang="en-US"><emph>Minimum:</emph> The minimum value of the sample.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431821789" role="ul_item" xml-lang="en-US"><emph>Maximum:</emph> The maximum value of the sample.</paragraph>
+</listitem></list>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id2308201415431870493" role="tablecontent" xml-lang="en-US">Normal</paragraph>
+</tablecell>
+<tablecell>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id2308201415431973994" role="ul_item" xml-lang="en-US"><emph>Mean:</emph> The mean of the Normal distribution.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431951090" role="ul_item" xml-lang="en-US"><emph>Standard Deviation:</emph> The standard deviation of the Normal distribution.</paragraph>
+</listitem></list>
+<paragraph id="par_id2308201415431990992" role="warning" xml-lang="en-US">The mean and standard deviation of the numbers generated may not equal the Mean and Standard Deviation inserted in the dialog.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id2308201415431912748" role="tablecontent" xml-lang="en-US">Cauchy</paragraph>
+</tablecell>
+<tablecell>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id2308201415431923135" role="ul_item" xml-lang="en-US"><emph>Median:</emph> the median of the data or location parameter.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431997296" role="ul_item" xml-lang="en-US"><emph>Sigma:</emph> the scale parameter.</paragraph>
+</listitem></list>
+<paragraph id="par_id2308201415431971536" role="warning" xml-lang="en-US">The median and sigma of the generated numbers may not equal the data inserted in the dialog.</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id2308201415431962173" role="tablecontent" xml-lang="en-US">Bernoulli</paragraph>
+</tablecell>
+<tablecell>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id2308201415431994157" role="ul_item" xml-lang="en-US"><emph>p Value:</emph> The probability of success.</paragraph>
+</listitem></list>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id2308201415431979367" role="tablecontent" xml-lang="en-US">Binomial</paragraph>
+</tablecell>
+<tablecell>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id2308201415431958372" role="ul_item" xml-lang="en-US"><emph>p Value:</emph> The probability of success of each trial.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431919718" role="ul_item" xml-lang="en-US"><emph>Number of trials:</emph> the number of trials of the experiment.</paragraph>
+</listitem></list>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id2308201415431985648" role="tablecontent" xml-lang="en-US">Chi Squared</paragraph>
+</tablecell>
+<tablecell>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id230820141543194944" role="ul_item" xml-lang="en-US"><emph>Nu Value: </emph>a positive integer that specifies the number of degrees of freedom.</paragraph>
+</listitem></list>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id2308201415431935636" role="tablecontent" xml-lang="en-US">Geometric</paragraph>
+</tablecell>
+<tablecell>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id2308201415431978150" role="ul_item" xml-lang="en-US"><emph>p Value:</emph> The probability of success of each trial.</paragraph>
+</listitem></list>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id230820141543197085" role="tablecontent" xml-lang="en-US">Negative Binomial</paragraph>
+</tablecell>
+<tablecell>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id2308201415431916718" role="ul_item" xml-lang="en-US"><emph>p Value:</emph> The probability of success of each trial.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431951891" role="ul_item" xml-lang="en-US"><emph>Number of trials:</emph> the number of trials of the experiment.</paragraph>
+</listitem></list>
+</tablecell>
+</tablerow>
+</table>
+<paragraph id="hd_id2308201415431232932" role="heading" xml-lang="en-US" level="2">Options</paragraph>
+<paragraph id="hd_id2308201415431832932" role="heading" xml-lang="en-US" level="3">Enable custom seed</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/enable-seed-check" id="bm_id3150793" localize="false"/>
+<paragraph id="par_id2308201415431841782" role="paragraph" xml-lang="en-US"><ahelp hid=".">Set the initial value of the random number generator to a known value <emph>Seed.</emph></ahelp></paragraph>
+<paragraph id="hd_id2308201415431881107" role="heading" xml-lang="en-US" level="3">Seed</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/seed-spin" id="bm_id3150794" localize="false"/>
+<paragraph id="par_id2308201415431834837" role="paragraph" xml-lang="en-US"><ahelp hid=".">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.</ahelp></paragraph>
+<paragraph id="hd_id2308201415431875641" role="heading" xml-lang="en-US" level="3">Enable rounding</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/enable-rounding-check" id="bm_id3150795" localize="false"/>
+<paragraph id="par_id2308201415431822157" role="paragraph" xml-lang="en-US"><ahelp hid=".">Truncate the number to a given number of <emph>Decimal Places</emph>.</ahelp></paragraph>
+<paragraph id="hd_id2308201415431826506" role="heading" xml-lang="en-US" level="3">Decimal places</paragraph>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/decimal-places-spin" id="bm_id3150796" localize="false"/>
+<paragraph id="par_id2308201415431820502" role="paragraph" xml-lang="en-US"><ahelp hid=".">Number of decimal places of the numbers generated.</ahelp></paragraph>
+</body>
+</helpdocument>