The approach of generating random numbers and scaling by their sum favors mid-size numbers at the expense of small and large numbers.
The approach described in post #5 favors large and small numbers at the expense of mid-size numbers.
The UDF at the cross-post generates numbers with a Dirichlet distribution, the same distribution as the numbers in all 5-element partitions of the sum.
Bookmarks