# Using Excel to generate empirical sampling distributions

Carr, Rodney and Salzman, Scott 2005, Using Excel to generate empirical sampling distributions, in ISI-55 : 2005 Session of the International Statistical Institute, International Statistical Institute, [Sydney, N.S.W.], pp. 1-4.

Attached Files
SYMPLECTIC-LICENCE Symplectic Licence text/plain 0
carr-usingexcel-2005.pdf Published version application/pdf 382.46KB 608

Title Using Excel to generate empirical sampling distributions Carr, Rodney Salzman, Scott International Statistical Institute Session (55th : 2005 : Sydney, N.S.W.) Sydney, N.S.W. 5-12 April 2005 ISI-55 : 2005 Session of the International Statistical Institute 2005 1 4 International Statistical Institute [Sydney, N.S.W.] Teachers in many introductory statistics courses demonstrate the Central Limit Theorem by using a computer to draw a large number of random samples of size n from a population distribution and plot the resulting empirical sampling distribution of the sample mean. There aremany computer applications that can be used for this (see, for example, the Rice Virtual Lab in Statistics: http://www.ruf.rice.edu/~lane/rvls.html). The effectiveness of such demonstrations has been questioned (see delMas et al (1999))) but in the work presented in this paper we do not rely on sampling distributions to convey or teach statistical concepts; only that the sampling distribution is independent of the distribution of the population, provided the sample size is sufficiently large.We describe a lesson that starts out with a demonstration of the CTL, but sample from a (finite) population where actual census data is provided; doing this may help students more easily relate to the concepts – they can see the original data as a column of numbers and if the samples are shown they can also see random samples being taken. We continue with this theme of sampling from census data to teach the basic ideas of inference. We end up with standard resampling/bootstrap procedures.We also demonstrate how Excel can provide a tool for developing a learning objects to support the program; a workbook called Sampling.xls is available from www.deakin.edu.au/~rodneyc/PS > Sampling.xls. Every reasonable effort has been made to ensure that permission has been obtained for items included in DRO. If you believe that your rights have been infringed by this repository, please contact drosupp@deakin.edu.au eng 089999 Information and Computing Sciences not elsewhere classified L2 Full written paper - non-refereed (minor conferences) http://hdl.handle.net/10536/DRO/DU:30015824

 Document type: Conference Paper Deakin Graduate School of Business Higher Education Research Group Open Access Collection
 Unless expressly stated otherwise, the copyright for items in DRO is owned by the author, with all rights reserved. Every reasonable effort has been made to ensure that permission has been obtained for items included in DRO. If you believe that your rights have been infringed by this repository, please contact drosupport@deakin.edu.au.
 Versions Version Filter Type Tue, 28 Jul 2009, 11:11:45 EST Tue, 28 Jul 2009, 11:32:58 EST Tue, 28 Jul 2009, 11:34:44 EST Tue, 28 Jul 2009, 11:36:56 EST Wed, 04 Aug 2010, 14:17:24 EST Wed, 04 Aug 2010, 14:19:54 EST Wed, 04 Aug 2010, 14:21:05 EST Tue, 04 Jun 2013, 13:50:37 EST Fri, 17 Oct 2014, 09:27:54 EST Filtered Full
Access Statistics: 632 Abstract Views, 608 File Downloads  -  Detailed Statistics Wed, 12 Nov 2008, 13:08:51 EST

Every reasonable effort has been made to ensure that permission has been obtained for items included in DRO. If you believe that your rights have been infringed by this repository, please contact drosupport@deakin.edu.au.