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.