I want to generate 1000 random numbers en VBA, but in frequencies as follows:
- 5% must be under 10K
- 90% must be between 10K and 50K
- 2.5% must be between 50K and 100K
- 2.5% must be over 100K
The occurrence is random and unordered.
Any suggestions about how to handle the ranges?
Thanks!
Aucun commentaire:
Enregistrer un commentaire