To Be Presented in the 11th Asian Technology Conference in Mathematics
December 12-16, 2006, Hong Kong SAR, China

Using EXCEL for Teaching Elementary Statistics

Lyn Bloom
l.bloom@ecu.edu.au

Ute Mueller
u.mueller@ecu.edu.au

Sandra Pereira
s.pereira@ecu.edu.au
School of Engineering and Mathematics
Edith Cowan University
Australia

Abstract

At Edith Cowan University we teach a number of units where it is necessary to introduce students to aspects of elementary statistics. Topics taught include summary statistics, probability distributions, confidence intervals, hypothesis testing and linear regression. Many of these students take only one or two statistics units in their course and a choice needs to be made as to what statistics package to use in these units. Factors such as cost, availability to both on-campus and on-line students, scope of the package and ease of use all need to be considered. Some students are from the social sciences areas and for these students we use the SPSS software package, for which the university has a comprehensive site licence. However, for other students, such as engineering and geostatistics students, we have opted for the less comprehensive but more widely available EXCEL. In this paper we detail, with relevant content illustrations, some of the advantages and disadvantages of our choice of EXCEL and discuss the subsequent curriculum changes that ensue.

close window Electronic Proceedings of ATCM
© ATCM, Inc. 2006