Advertisement

Random Number Generator

  • Thomas Quirk
Chapter

Abstract

This chapter explains how to use Excel to take a random sample of people (or objects) from a sampling frame that contains the list of people (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 duplicate 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 for each chapter is presented in the Practice Test given in Appendix B along with the answers in Appendix C of this book.

Reference

  1. U.S. Census Bureau Census 2000 PHC-T-4. Ranking tables for counties 1990 and 2000. Retrieved from http://www.census.gov/population/www/cen2000/briefs/phc-t4/tables/tab01.pdf

Copyright information

© Springer Science+Business Media, LLC 2012

Authors and Affiliations

  1. 1.School of Business and TechnologyWebster UniversitySt. LouisUSA

Personalised recommendations