Random Data Generator
A very easy way;
In A1 thru A5 enter data1
in A6 thru A17 enter data2
Continue until you reach 100% in A100
In B1 thru B100 enter:
=RAND()
then sort cols A & B by B
Any sample pulled from column A will satisfy the distribution in the average.
--
Gary''s Student - gsnu200814
"Bill" wrote:
I have a data set that I created a block grid and a random genereator for. I
would like to put a percentage in for each piece of data so that data 1 is
only 5%, data 2 is 12% etc... How do I assign those percentages?
|