Friday, April 27, 2018

yogi_Create A List Of Random Numbers Between 1 and 11 With 80 Percent Between 1 and 10 and 20 Percent of 11s

Google Spreadsheet   Post  #2433

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-27-2018

question by: _Drew C
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/n5pfPqzAAHc;context-place=forum/docs

Random number generator with known group results

I need to generate a random number between 1 and 11 for hundreds of cells while capping the number of each value.

I.E. If I need to sort 1000 individual units, I want values 1-10 to have 80 instances and 11 to have 200. Is this possible?