Deakin home > Deakin University Library > Deakin Research Online > Using Excel to generate empirical sampling distributions
Openly accessible

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 (Some files may be inaccessible until you login with your Deakin Research Online credentials)
Name Description MIMEType Size Downloads
carr-usingexcel-2005.pdf Published version application/pdf 382.46KB 83

Title Using Excel to generate empirical sampling distributions
Author(s) Carr, Rodney
Salzman, Scott
Conference name International Statistical Institute Session (55th : 2005 : Sydney, N.S.W.)
Conference location Sydney, N.S.W.
Conference dates 5-12 April 2005
Title of proceedings ISI-55 : 2005 Session of the International Statistical Institute
Publication date 2005
Start page 1
End page 4
Publisher International Statistical Institute
Place of publication [Sydney, N.S.W.]
Summary 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 are
many 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.
Notes
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
Language eng
Field of Research 089999 Information and Computing Sciences not elsewhere classified
HERDC Research category L2 Full written paper - non-refereed (minor conferences)
Persistent URL http://hdl.handle.net/10536/DRO/DU:30015824

Connect to link resolver
 
Unless expressly stated otherwise, the copyright for items in Deakin Research Online 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
Access Statistics: 544 Abstract Views, 83 File Downloads  -  Detailed Statistics
Created: Wed, 12 Nov 2008, 13:08:51 EST