diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/02140700.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/02140700.xhp | 194 |
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> |