making random sorts in Microsoft Excel (Macintosh)

[Allannah_Thomas]

Can someone tell me the name of software that will enable me to sort data randomly in Microsoft Excel (Macintosh)? Thanks

 

[Mike Middleton]

Allannah_Thomas -

One way is to enter =RAND() in an adjacent helper column and sort using the
random numbers as the key.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



Can someone tell me the name of software that will enable me to sort data
randomly in Microsoft Excel (Macintosh)? Thanks

 

[JE McGimpsey]

Can someone tell me the name of software that will enable me to sort data
randomly in Microsoft Excel (Macintosh)? Thanks

Excel would be one...

The easiest way is to, in an adjacent column, enter

=RAND()

and copy down as far as your data goes. Sort on that column.

 

[ltkaku]

Is there a way of randomly assigning number 1 or 2 for a total of 60 students so 30 would be 1 and 30 would be 2.

 

[Mike Middleton]

ltkaku -

One way is to enter =RAND() in an adjacent helper column, select the data in
all columns, and sort (Data | Sort ...) using the random numbers as the key.

Then assign 1 to the top 30 students and 2 to the other 30.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[PhilD]

One way is to enter =RAND() in an adjacent helper column, select the data in
all columns, and sort (Data | Sort ...) using the random numbers as the key.

Then assign 1 to the top 30 students and 2 to the other 30.

... and if you don't like the random results, just sort again. The
random number is recalculated each time so you don't need to enter the
formula again.


PhilD