Research Article Open Access

Using the Spreadsheet to Understand Random Sampling Procedures in Relation to the Central Limit Theorem

Ramzi Naim Nasser

Abstract

In many statistics courses in colleges and universities, random sampling has not been presented to students through a hands-on and practical approach. This research described a real-life method to random sampling was used as an exercise in the statistics class. The method allowed students to recursively select 5, 10, 20, 30, 40, 50, 60 and 70 samples and list these samples in a matrix-spreadsheet. Students used the spreadsheet software-EXCEL, calculated the statistics and performed graphical computations. Students were engaged to reflect and develop a sense of meaning of randomness in its relation to the law of large numbers. Specifically, the method explored an increase in the number of samples, how it changed the means, mean of means or standard deviations- This is an instructional study which devices a working approach to random sampling.

Journal of Mathematics and Statistics
Volume 4 No. 3, 2008, 168-173

DOI: https://doi.org/10.3844/jmssp.2008.168.173

Submitted On: 3 September 2008 Published On: 30 September 2008

How to Cite: Nasser, R. N. (2008). Using the Spreadsheet to Understand Random Sampling Procedures in Relation to the Central Limit Theorem . Journal of Mathematics and Statistics, 4(3), 168-173. https://doi.org/10.3844/jmssp.2008.168.173

  • 2,830 Views
  • 2,014 Downloads
  • 0 Citations

Download

Keywords

  • Central limit theorem
  • law of large numbers
  • random sampling
  • resampling
  • mean
  • mean of means
  • shrinking means