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 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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Frankfort-Nachmias, C. and Nachmias, D. Research Methods in the Social Sciences (7th ed.). New York, NY: Worth Publishers, 2008.
Howell, W.G., Wolf, P.J., Campbell, D.E., and Peterson, P.E. “Test-Score Effects of School Vouchers in Dayton, Ohio, New York City, and Washington, D.C.: Evidence from Randomized Field Trials.” Paper presented at the annual meeting of the American Political Science Association, Washington, D.C., September 2000.
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
© 2015 Springer International Publishing Switzerland
About this chapter
Cite this chapter
Quirk, T.J. (2015). Random Number Generator. In: Excel 2013 for Social Sciences Statistics. Excel for Statistics. Springer, Cham. https://doi.org/10.1007/978-3-319-19177-5_2
Download citation
DOI: https://doi.org/10.1007/978-3-319-19177-5_2
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-19176-8
Online ISBN: 978-3-319-19177-5
eBook Packages: Mathematics and StatisticsMathematics and Statistics (R0)