China Naming Network - Ziwei Dou Shu - Generate random numbers according to a certain proportion in excel.

Generate random numbers according to a certain proportion in excel.

1. Enter the following in column A.

=INT(RAND()* 10)+90, 10 drop down;

=INT(RAND()* 10)+80, drop down18;

=INT(RAND()* 10)+70, drop down14;

=INT(RAND()* 10)+60, drop down 8;

2. Enter =rand () in column B and drop it down to 50;

3. Column B is sorted in ascending or descending order, and the numbers in column A can be considered as randomly generated.

Note that column A changes all the time, and you can paste values selectively.