I would like random numbers between 0 and 7. To go from a2:a10000. But I would like the probability's of each number to not be equally random.
For example I would the number 7 to appear 1.52%. of the time.
Here is each number probability of appearing
0 0.003736695
1 0.031969498
2 0.117221491
3 0.23878452
4 0.291847746
5 0.21402168
6 0.087194018
7 0.015224352
Any help is greatly appreciated
Bookmarks