jeudi 23 juillet 2020

Generate random numbers distributed in 4 ranges in VBA

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