Random Number Generator

Part of the Excel for Statistics book series (EXCELSTAT)


This chapter explains how to use Excel to take a random sample of events or objects from a sampling frame that contains the list of events or objects from which you want to take a random sample. You will learn how to use Excel to create frame numbers for generating random numbers, why a set of duplicate frame numbers is important, and the Excel commands needed to sort the frame numbers into a random sequence. In addition, you will learn how to print out your result so that all of the information fits entirely onto a single page of paper. Three practice problems are given at the end of the chapter to test your Excel skills, and the answers to these problems appear in Appendix A of this book. An additional practice problem is presented in the Practice Test given in Appendix B along with its answer in Appendix C of this book.


Random Number Salt Marsh Frame Number Field Mouse Practice Problem 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  1. 1.Webster UniversitySt. LouisUSA
  2. 2.BaileyUSA
  3. 3.Colorado Parks and WildlifeDenverUSA

Personalised recommendations