<?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 id="tit">Fill Random Numbers</title> <filename>/text/scalc/01/02140700.xhp</filename> </topic> </meta> <body> <bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog" id="bm_id3150791" localize="false"/> <bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/@@nowidget@@" id="bm_id3150791" localize="false"/> <section id="fill_random_numbers"> <h1 id="hd_id2308201415431520596"><link href="text/scalc/01/02140700.xhp">Fill Random Numbers</link></h1> <paragraph id="par_id2308201415431525817" role="paragraph"><ahelp hid=".">Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters.</ahelp></paragraph> </section> <bookmark 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"> <embed href="text/scalc/00/00000402.xhp#fill_random"/> </section> <h2 id="hd_id2308201415431233475">Data</h2> <h3 id="hd_id2308201415431883475">Cell Range</h3> <bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/cell-range-edit" id="bm_id3150792" localize="false"/> <paragraph id="par_id2308201415431811111" role="paragraph"><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> <h2 id="hd_id2308201415431850229">Random number generator</h2> <h3 id="hd_id2308201415431880497">Distribution</h3> <bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/distribution-combo" id="bm_id2308201416384294287" localize="false"/> <paragraph id="par_id2308201415431874867" role="paragraph"><ahelp hid=".">The distribution function for the random number generator.</ahelp></paragraph> <paragraph id="par_id2308201416441240058" role="paragraph">Valid distributions function and their parameters are</paragraph> <table id="Tabela1"> <tablerow> <tablecell> <paragraph id="par_id230820141543181813" role="tablehead">Distribution</paragraph> </tablecell> <tablecell> <paragraph id="par_id2308201415431868807" role="tablehead">Parameters</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> <paragraph id="par_id2308201415431869872" role="tablecontent">Uniform</paragraph> </tablecell> <tablecell> <list type="unordered"> <listitem> <paragraph id="par_id2308201415431850857" role="ul_item"><emph>Minimum:</emph> The minimum value of the sample.</paragraph> </listitem> <listitem> <paragraph id="par_id2308201415431859422" role="ul_item"><emph>Maximum:</emph> The maximum value of the sample.</paragraph> </listitem></list> </tablecell> </tablerow> <tablerow> <tablecell> <paragraph id="par_id2308201415431848733" role="tablecontent">Uniform Integer</paragraph> </tablecell> <tablecell> <list type="unordered"> <listitem> <paragraph id="par_id2308201415431813421" role="ul_item"><emph>Minimum:</emph> The minimum value of the sample.</paragraph> </listitem> <listitem> <paragraph id="par_id2308201415431821789" role="ul_item"><emph>Maximum:</emph> The maximum value of the sample.</paragraph> </listitem></list> </tablecell> </tablerow> <tablerow> <tablecell> <paragraph id="par_id2308201415431870493" role="tablecontent">Normal</paragraph> </tablecell> <tablecell> <list type="unordered"> <listitem> <paragraph id="par_id2308201415431973994" role="ul_item"><emph>Mean:</emph> The mean of the Normal distribution.</paragraph> </listitem> <listitem> <paragraph id="par_id2308201415431951090" role="ul_item"><emph>Standard Deviation:</emph> The standard deviation of the Normal distribution.</paragraph> </listitem></list> <warning id="par_id2308201415431990992">The mean and standard deviation of the numbers generated may not equal the Mean and Standard Deviation inserted in the dialog.</warning> </tablecell> </tablerow> <tablerow> <tablecell> <paragraph id="par_id2308201415431912748" role="tablecontent">Cauchy</paragraph> </tablecell> <tablecell> <list type="unordered"> <listitem> <paragraph id="par_id2308201415431923135" role="ul_item"><emph>Median:</emph> the median of the data or location parameter.</paragraph> </listitem> <listitem> <paragraph id="par_id2308201415431997296" role="ul_item"><emph>Sigma:</emph> the scale parameter.</paragraph> </listitem></list> <warning id="par_id2308201415431971536">The median and sigma of the generated numbers may not equal the data inserted in the dialog.</warning> </tablecell> </tablerow> <tablerow> <tablecell> <paragraph id="par_id2308201415431962173" role="tablecontent">Bernoulli</paragraph> </tablecell> <tablecell> <list type="unordered"> <listitem> <paragraph id="par_id2308201415431994157" role="ul_item"><emph>p Value:</emph> The probability of success.</paragraph> </listitem></list> </tablecell> </tablerow> <tablerow> <tablecell> <paragraph id="par_id2308201415431979367" role="tablecontent">Binomial</paragraph> </tablecell> <tablecell> <list type="unordered"> <listitem> <paragraph id="par_id2308201415431958372" role="ul_item"><emph>p Value:</emph> The probability of success of each trial.</paragraph> </listitem> <listitem> <paragraph id="par_id2308201415431919718" role="ul_item"><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">Chi Squared</paragraph> </tablecell> <tablecell> <list type="unordered"> <listitem> <paragraph id="par_id230820141543194944" role="ul_item"><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">Geometric</paragraph> </tablecell> <tablecell> <list type="unordered"> <listitem> <paragraph id="par_id2308201415431978150" role="ul_item"><emph>p Value:</emph> The probability of success of each trial.</paragraph> </listitem></list> </tablecell> </tablerow> <tablerow> <tablecell> <paragraph id="par_id230820141543197085" role="tablecontent">Negative Binomial</paragraph> </tablecell> <tablecell> <list type="unordered"> <listitem> <paragraph id="par_id2308201415431916718" role="ul_item"><emph>p Value:</emph> The probability of success of each trial.</paragraph> </listitem> <listitem> <paragraph id="par_id2308201415431951891" role="ul_item"><emph>Number of trials:</emph> the number of trials of the experiment.</paragraph> </listitem></list> </tablecell> </tablerow> <tablerow> <tablecell> <paragraph id="par_id2308201415432870493" role="tablecontent">Poisson</paragraph> </tablecell> <tablecell> <list type="unordered"> <listitem> <paragraph id="par_id2308201415432973994" role="ul_item"><emph>Mean:</emph> The mean of the Poisson distribution.</paragraph> </listitem></list> </tablecell> </tablerow> </table> <h2 id="hd_id2308201415431232932">Options</h2> <h3 id="hd_id2308201415431832932">Enable custom seed</h3> <bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/enable-seed-check" id="bm_id3150793" localize="false"/> <paragraph id="par_id2308201415431841782" role="paragraph"><ahelp hid=".">Set the initial value of the random number generator to a known value <emph>Seed.</emph></ahelp></paragraph> <h3 id="hd_id2308201415431881107">Seed</h3> <bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/seed-spin" id="bm_id3150794" localize="false"/> <paragraph id="par_id2308201415431834837" role="paragraph"><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> <h3 id="hd_id2308201415431875641">Enable rounding</h3> <bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/enable-rounding-check" id="bm_id3150795" localize="false"/> <paragraph id="par_id2308201415431822157" role="paragraph"><ahelp hid=".">Round the number to a given number of <emph>Decimal Places</emph>.</ahelp></paragraph> <h3 id="hd_id2308201415431826506">Decimal places</h3> <bookmark branch="hid/modules/scalc/ui/randomnumbergenerator/decimal-places-spin" id="bm_id3150796" localize="false"/> <paragraph id="par_id2308201415431820502" role="paragraph"><ahelp hid=".">Number of decimal places of the numbers generated.</ahelp></paragraph> </body> </helpdocument>