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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReference
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
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG, part of Springer Nature
About this chapter
Cite this chapter
Quirk, T.J. (2018). Random Number Generator. In: Excel 2016 in Applied Statistics for High School Students. Excel for Statistics. Springer, Cham. https://doi.org/10.1007/978-3-319-89993-0_2
Download citation
DOI: https://doi.org/10.1007/978-3-319-89993-0_2
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-89992-3
Online ISBN: 978-3-319-89993-0
eBook Packages: Mathematics and StatisticsMathematics and Statistics (R0)