Random Number Generator

  • Thomas J. Quirk
  • Eric Rhiney
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.

Copyright information

© Springer Nature Switzerland AG 2020

Authors and Affiliations

  • Thomas J. Quirk
    • 1
  • Eric Rhiney
    • 2
  1. 1.Professor of MarketingWebster UniversitySt. LouisUSA
  2. 2.Associate Professor of MarketingWebster UniversitySt. LouisUSA

Personalised recommendations