Randomly group a list of people

  • Thread starter Thread starter saw@rmh
  • Start date Start date
S

saw@rmh

I've got a team of 50 kids that need to practice in groups of no more
than 10. Each group will be led by a different coach. In order to
have all 5 coaches see the performance of a different group of kids
each week, I would like to randomly sort and group the kids. This also
allows different kids to practice with a different group of other kids
each week. Can anyone help me figure out how to do this?
 
One way:

List the 50 kids in column A. In column B, put

=RAND()

in row 1 and copy down to B50. Choose Data/Sort and sort on column
B. Choose the first 10 kids for Coach A, second 10 for Coach B, etc.
For the next week, just sort on column B again.
 
Saw

If you want every coach to see every player, you can't just randomly assign players to coaches. You need a balanced statistical
design. Below is a 50
player design where each player is assigned to each of the 5 coaches, in
blocks of ten players, for the five sessions. The number given is the coach number for the session. This is not the only possible
design, just one of many.

HTH,
Bernie

Ses1 Ses2 Ses3 Ses4 Ses5
Player 1 1 2 3 4 5
Player 2 1 2 4 3 5
Player 3 1 3 2 5 4
Player 4 1 3 4 5 2
Player 5 1 3 5 2 4
Player 6 1 4 2 3 5
Player 7 1 4 3 5 2
Player 8 1 5 2 4 3
Player 9 1 5 2 3 4
Player 10 1 5 4 2 3
Player 11 2 1 3 5 4
Player 12 2 1 4 3 5
Player 13 2 1 5 4 3
Player 14 2 3 1 4 5
Player 15 2 3 5 4 1
Player 16 2 4 1 5 3
Player 17 2 4 3 5 1
Player 18 2 4 5 1 3
Player 19 2 5 1 3 4
Player 20 2 5 3 4 1
Player 21 3 1 2 4 5
Player 22 3 1 4 5 2
Player 23 3 2 1 5 4
Player 24 3 2 4 1 5
Player 25 3 2 5 4 1
Player 26 3 4 2 5 1
Player 27 3 4 5 1 2
Player 28 3 5 1 4 2
Player 29 3 5 2 1 4
Player 30 3 5 4 2 1
Player 31 4 1 5 2 3
Player 32 4 1 3 2 5
Player 33 4 1 5 3 2
Player 34 4 2 1 3 5
Player 35 4 2 5 1 3
Player 36 4 3 1 2 5
Player 37 4 3 2 5 1
Player 38 4 3 5 1 2
Player 39 4 5 2 1 3
Player 40 4 5 3 1 2
Player 41 5 1 3 2 4
Player 42 5 1 4 2 3
Player 43 5 2 1 4 3
Player 44 5 2 3 1 4
Player 45 5 2 4 3 1
Player 46 5 3 1 2 4
Player 47 5 3 4 1 2
Player 48 5 4 1 3 2
Player 49 5 4 2 3 1
Player 50 5 4 3 2 1
 
Bernie,

Sorry it took so long to reply... Thanks for your help. However, I'
trying to figure out what you did here. Did you use a formula t
create this?


Scott
 
Back
Top