I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbExactRandHistogrm

It is fairly easy to create a loaded die, let us say on average the 6 should appear twice as often as all the other numbers 1 thru 5: Enter into A1: =MIN(INT(RAND()*7+1),6)

But what if you want to create 7 rolls of this die and all numbers between 1 and 5 should appear exactly once and 6 exactly twice?

Here is my general solution:

sbExactRandHistogrm_01_Screen
sbExactRandHistogrm_01_Code
sbExactRandHistogrm_02_Code
sbExactRandHistogrm_03_Code

Other, but similar methods are shown at D’Hondt Method and at Largest Remainder Method.

If you are interested in downloading a 29 KB Excel 2010 © sample file go to my download page, please.

Sulprobil   Get it done   Contact   Disclaimer   Download