Step 4:  Determine the method of selecting the sample

• • create 5 unique samples using the 5 techniques below. Create a separate worksheet for each sample.
  • • simple random sampling (hint: you can use the =rand() formula in Excel.  Enter the rand() formula> paste values> sort by pasted values> take the top observations)
  • • systematic random sampling  (hint: you can select every nth observation)
  • • haphazard sampling
  • • block sampling
  • • stratification sampling