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

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?
 
G

Guest

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

Random Numbers 4
eliminate negative value from normal random number distribution 4
How can I sort a column of numbers generated by excel RAND funct? 5
How do I convert a column of numbers from positive to negative? 3
How do I average positive numbers only 2
random number generator 8
Restrain random number to positive numbers 5
Seed numbers for random number generation, uniform distribution 2

Top