Ask Your Question

how to insert values of uniform distribution into a column

asked 2017-08-15 20:24:06 +0200

raymondvillain gravatar image

updated 2017-08-15 20:38:13 +0200

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.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-08-15 21:23:27 +0200

Lupp gravatar image

Select 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'.)

edit flag offensive delete link more

answered 2017-08-16 02:35:24 +0200

raymondvillain gravatar image

Thanks! Much appreciated. Kept looking for "Fill" but could not find it.

edit flag offensive delete link more


Happy 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!

Lupp gravatar imageLupp ( 2017-08-16 10:18:26 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-15 20:24:06 +0200

Seen: 152 times

Last updated: Aug 16 '17