Hi folks,
I've 7 numbers (-3 to +3) that I need to distribute randomly (as best we can) 2539 times between other entries.
If possible, as close as we can to the following weights... This is the best way I could phrase it...
-3 |
-2 |
-1 |
0 |
1 |
2 |
3 |
0.05 |
0.1 |
0.2 |
0.3 |
0.2 |
0.1 |
0.05 |
Any ideas? I'm sure I've seen a post on here similar to this, and I've tried to mod the following code to suit my needs, but I can't quite get it to work, I think because of the duplicated weights...
=CHOOSE(MATCH(RAND(),{0,0.44,0.6,0.71},1),"A","B","C","D")
Bookmarks