Re: Assigning values randomly to percentage of records

[Katie Jones]

I can't seem to edit the post but the random numbers/letters in the middle of the post should have been a table showing the 8 possible categories (each record has either a 0 or a 1 for cat 1, 2 3), the number of records assigned to each of those, what proportion of the total records they are, and then what the 5% proportion should be:


cat 1 cat 2 cat 3 CUSTOMERS PROPORTION 5% CONTROL
NONE 0 0 0 13,279,830 26% 663,992
CAT 2 ONLY 0 1 0 7,044 0% 352
ALL 1 1 1 1,514,488 3% 75,724
CAT 1 AND 3 1 0 1 1,351,439 3% 67,572
CAT 3 ONLY 0 0 1 28,989,956 57% 1,449,498
CAT 1 ONLT 1 0 0 29,637 0% 1,482
CAT 2 AND 3 0 1 1 5,410,809 11% 270,540
CAT 1 AND 2 1 1 0 12,044 0% 602
50,595,247 2,529,762