Skip to main content

Random Number Generator

  • Chapter
  • First Online:
Excel 2010 for Social Science Statistics

Abstract

Suppose that a local school superintendent asked you to take a random sample of 5 of an elementary school’s 32 teachers using Excel so that you could interview these five teachers about their job satisfaction at their school.

To do that, you need to define a “sampling frame.” A sampling frame is a list of people from which you want to select a random sample. This frame starts with the identification code (ID) of the number 1 that is assigned to the name of the first teacher in your list of 32 teachers in this school. The second teacher has a code number of 2, the third a code number of 3, and so forth until the last teacher has a code number of 32.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

eBook
USD 16.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  • Frankfort-Nachmias, C. and Nachmias, D. Research Methods in the Social Sciences (7th ed.). New York, NY: Worth Publishers, 2008.

    Google Scholar 

  • 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.

    Google Scholar 

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

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Thomas J. Quirk Ph.D., M.B.A., M.A. .

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer Science+Business Media New York

About this chapter

Cite this chapter

Quirk, T.J. (2012). Random Number Generator. In: Excel 2010 for Social Science Statistics. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-3637-9_2

Download citation

Publish with us

Policies and ethics