Example of sample from columns

A researcher has ten applicants for an experiment but needs only five applicants. The researcher uses random sample to randomly select five of the applicants.

  1. In the column name cell, enter Name.
  2. Copy and paste, or type the following data into the Name column:
    Amal
    Ana
    Chloe
    Fin
    Joon
    Jordon
    Luis
    Michael
    Sam
    Sarah
  3. Open the Sample from Columns dialog box.
    • Mac: Data > Sample from Columns
    • PC: DATA > Sample from Columns
  4. In Take a sample from the following columns, enter Name.
  5. In Number of rows in each sample, enter 5.
  6. Click OK.

Results

The first column contains all 10 applicants. The second column contains the random sample of five applicants. The researcher can record the results of the experiment in the corresponding rows of another column.

C1 C2
Name Sample From Name
Amal Joon
Ana Ana
Chloe Luis
Fin Sam
Joon Fin
Jordon  
Luis  
Michael  
Sam  
Sarah  
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy