How can I get Positive values only from the random number generat.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am generating a random group of numbers using Excel's add-in "Random Number
Generator". I am using the normal distribution, but I want positive values
only. I know that the test I am doing will work with the negative values I
have generated, because the mean/stdev are correct. However, the activity
for which the numbers are associated can never be negative, so my
presentation will be less effective. Any ideas?
 
You could use the randbetween function and specify a positive range i.e.
=Randbetween(1,10000000)


HTH

Jimbola
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

eliminate negative value from normal random number distribution 4
Random Numbers 4
RAND() generates negative values??? 2
random number generator 8
How can I sort a column of numbers generated by excel RAND funct? 5
Non Uniform Random Number Generator 2
Seed numbers for random number generation, uniform distribution 2
VBA "Rnd" Function: Truly Random? 2

Back
Top