| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I get Positive values only from the random number generat.
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? |
|
#2
|
|||
|
|||
|
You could use the randbetween function and specify a positive range i.e.
=Randbetween(1,10000000) HTH Jimbola "Markw3700" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Running Total of Random Number | Excel Discussion (Misc queries) | |||
| Generating Correlated Random Values in Excel | Excel Discussion (Misc queries) | |||
| Is there a way to have two values (percent and number) in a label. | Charts and Charting in Excel | |||
Linear Mode
