Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 16 Aug 2017 10:18:26 +0200how to insert values of uniform distribution into a columnhttps://ask.libreoffice.org/en/question/123103/how-to-insert-values-of-uniform-distribution-into-a-column/Wish to select a column (in a Calc spreadsheet) of length 10, say, E10 through E19, and populate it with integer values from a specified interval of a uniform distribution.
From the menu, I select Insert > function to bring up a box, under "category" I select "statistical", but there does not appear to be a uniform distribution available.Tue, 15 Aug 2017 20:24:06 +0200https://ask.libreoffice.org/en/question/123103/how-to-insert-values-of-uniform-distribution-into-a-column/Answer by raymondvillain for <p>Wish to select a column (in a Calc spreadsheet) of length 10, say, E10 through E19, and populate it with integer values from a specified interval of a uniform distribution.</p>
<p>From the menu, I select Insert > function to bring up a box, under "category" I select "statistical", but there does not appear to be a uniform distribution available.</p>
https://ask.libreoffice.org/en/question/123103/how-to-insert-values-of-uniform-distribution-into-a-column/?answer=123118#post-id-123118Thanks! Much appreciated. Kept looking for "Fill" but could not find it.
Wed, 16 Aug 2017 02:35:24 +0200https://ask.libreoffice.org/en/question/123103/how-to-insert-values-of-uniform-distribution-into-a-column/?answer=123118#post-id-123118Comment by Lupp for <p>Thanks! Much appreciated. Kept looking for "Fill" but could not find it.</p>
https://ask.libreoffice.org/en/question/123103/how-to-insert-values-of-uniform-distribution-into-a-column/?comment=123269#post-id-123269Happy to have helped.
You can emphsise for other users that there is a solution to your question here by clicking the checkmark left of the answer.
Your "Thanks" might have been posted as a comment to my answer, since it is not an answer itself.
Thanks in retuirn!Wed, 16 Aug 2017 10:18:26 +0200https://ask.libreoffice.org/en/question/123103/how-to-insert-values-of-uniform-distribution-into-a-column/?comment=123269#post-id-123269Answer by Lupp for <p>Wish to select a column (in a Calc spreadsheet) of length 10, say, E10 through E19, and populate it with integer values from a specified interval of a uniform distribution.</p>
<p>From the menu, I select Insert > function to bring up a box, under "category" I select "statistical", but there does not appear to be a uniform distribution available.</p>
https://ask.libreoffice.org/en/question/123103/how-to-insert-values-of-uniform-distribution-into-a-column/?answer=123106#post-id-123106Select the range, then go >'Sheet' > 'Fill Cells' > 'Random Number...' and be happy with the plethora of offers.
(In olĂ¶der versions ''Fill' was under 'Edit'.)Tue, 15 Aug 2017 21:23:27 +0200https://ask.libreoffice.org/en/question/123103/how-to-insert-values-of-uniform-distribution-into-a-column/?answer=123106#post-id-123106