Creating a Simple Random Sample in Microsoft® Excel

Chapter 2, Printout 1

  1. Launch Excel.

  2. Fill Column A with values 1-80.

    Column A now contains the integers 1-80.

    Screenshot: screenshot

  3. Fill Rows 1-25 of Column B with a Random Sample from Column A.

    Column B now contains a random sample of 25 values from Column A.

    Screenshot: screenshot