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

Journal of Mathematics and Statistics

Ramzi N. Nasser¹ 

关键词: Central limit theorem;    law of large numbers;    random sampling;    resampling;    mean;    mean of means;    shrinking means;   

DOI  :  10.3844/jmssp.2008.168.173

学科分类：社会科学、人文和艺术（综合）

来源: Science Publications

【 摘 要 】

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.

【 授权许可】

Unknown