1
vote
3answers
10k views

excel: how to use vba to repeatedly generate random numbers?

I know that in Excel one can use "rand()" function to generate random numbers, and each time pressing F9, all "rand()" results on that sheet will be refreshed. However, now I need to repeated ...
0
votes
1answer
5k views

MS Excel: Unique random number generator within a range

I searched for a similar question but couldn't find one.. I want to generate 10 groups out of numbers ranging from 1-60 (including both), with each and every group containing random and non-repeating ...
2
votes
1answer
185 views

Calculating mean of value across random trials/refreshes in Excel?

Say I have a 1000 cells filled with random values and a particular cell that computes a final answer based on those 1000 values. Now I wish to track the value of the answer over 1000 trials i.e., I ...
1
vote
1answer
1k views

Math Round multiple cells, generate integers and histogram integer values

I want your help for the following points: How generate integer values using Data menu > Data Analysis > Random Number Generation or (if this action can't be done) how round multiple cells in same ...