If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Random Sample
I have a list of data in excel. Is there anyway that excel can pick a randam
sample of say 20 entries? |
#2
|
|||
|
|||
Random Sample
Say the data is in column A from A1 thru A1000.
In B1 thru B1000 enter: =RAND() Sort cols A&B by B. This will "shuffle" the items in column A. Just pick the top 20 items in col A. Re-sort to get another sample. -- Gary''s Student - gsnu200805 "Funkyfido" wrote: I have a list of data in excel. Is there anyway that excel can pick a randam sample of say 20 entries? |
#3
|
|||
|
|||
Random Sample
Hi,
Say your data are in colimn A put this in b1 and double click the fill handle to make it fill down:- =Rand() Now select Columns A & B and sort on column B. The top 20 elements in column A are randomely selected from the list. Tap F9 and re-sort for another 20. Mike "Funkyfido" wrote: I have a list of data in excel. Is there anyway that excel can pick a randam sample of say 20 entries? |
Thread Tools | |
Display Modes | |
|
|