summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@edx.srv.br>2014-08-23 17:22:38 -0300
committerJoren De Cuyper <jorendc@libreoffice.org>2014-08-24 14:55:46 -0500
commitc124f21d9c10bd56bfe8c1b1e89a898c360372a0 (patch)
treea776e554477e82ed93569fe209bf858d8ef22bd5
parentba90edc72a3eedc95f2a2bd2c6923b860cc3e4d8 (diff)
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 <jorendc@libreoffice.org> Tested-by: Joren De Cuyper <jorendc@libreoffice.org>
-rw-r--r--AllLangHelp_scalc.mk1
-rw-r--r--source/text/scalc/01/02140700.xhp219
2 files changed, 220 insertions, 0 deletions
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 @@
+<?xml version="1.0"?>
+<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="Indexer" 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"/>
+<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">Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters.</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">Menu <item type="menuitem">Edit – Fill – Random Numbers</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>
+<paragraph id="par_id2308201415431811111" role="paragraph" xml-lang="en-US">Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here.</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/RandomNumberGeneratorDialog/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 are</paragraph>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id2308201415431818046" role="ul_item" xml-lang="en-US">Uniform</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431825918" role="ul_item" xml-lang="en-US">Uniform Integer</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431836211" role="ul_item" xml-lang="en-US">Normal</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431849631" role="ul_item" xml-lang="en-US">Cauchy</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431835163" role="ul_item" xml-lang="en-US">Bernoulli</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431855317" role="ul_item" xml-lang="en-US">Binomial</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431846096" role="ul_item" xml-lang="en-US">Chi Squared</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431871139" role="ul_item" xml-lang="en-US">Geometric</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id2308201415431873378" role="ul_item" xml-lang="en-US">Negative Binomial</paragraph>
+</listitem></list>
+<paragraph id="hd_id2308201415431832932" role="heading" xml-lang="en-US" level="3">Enable custom seed</paragraph>
+<paragraph id="par_id2308201415431841782" role="paragraph" xml-lang="en-US">Set the initial value of the random number generator to a known value <emph>Seed.</emph></paragraph>
+<paragraph id="hd_id2308201415431881107" role="heading" xml-lang="en-US" level="3">Seed</paragraph>
+<paragraph id="par_id2308201415431834837" role="paragraph" xml-lang="en-US">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.</paragraph>
+<paragraph id="hd_id2308201415431875641" role="heading" xml-lang="en-US" level="3">Enable rounding</paragraph>
+<paragraph id="par_id2308201415431822157" role="paragraph" xml-lang="en-US">Truncate the number to a given number of <emph>Decimal Places</emph>.</paragraph>
+<paragraph id="hd_id2308201415431826506" role="heading" xml-lang="en-US" level="3">Decimal places</paragraph>
+<paragraph id="par_id2308201415431820502" role="paragraph" xml-lang="en-US">Number of decimal places of the numbers generated.</paragraph>
+<paragraph id="hd_id2308201415431872246" role="heading" xml-lang="en-US" level="2">Parameters</paragraph>
+<paragraph id="par_id2308201415431897703" role="paragraph" xml-lang="en-US">Depending on the selected distribution, the parameters describe properties for the number generators. The table below summarizes the parameters of each distribution:</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>
+
+<section id="relatedtopics">
+<paragraph id="par_id230820141705438801" role="paragraph" xml-lang="en-US">For more information on the distributions, see the Wikipedia</paragraph>
+</section>
+</body>
+</helpdocument> \ No newline at end of file