diff options
| author | Olivier Hallot <olivier.hallot@edx.srv.br> | 2014-08-23 17:22:38 -0300 |
|---|---|---|
| committer | Joren De Cuyper <jorendc@libreoffice.org> | 2014-08-24 14:55:46 -0500 |
| commit | c124f21d9c10bd56bfe8c1b1e89a898c360372a0 (patch) | |
| tree | a776e554477e82ed93569fe209bf858d8ef22bd5 /source | |
| parent | ba90edc72a3eedc95f2a2bd2c6923b860cc3e4d8 (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>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/02140700.xhp | 219 |
1 files changed, 219 insertions, 0 deletions
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 |