Teaching Statistics with Excel A Big Challenge for Students and Lecturers

  • Christine Duller Johannes Kepler University Linz

Abstract

This paper has a look on the implementation of basic statistical methods in Excel, in particular in describing data. Often a frequency distribution is the starting point for describing a dataset, but its calculation is not that easy in Excel. Therefore the first section gives some alternatives to the common way. The next part presents some interesting solutions for measures of central tendency and variability provided by Excel. The last important topic is about creating graphs, where Excel has an advantage: creating histograms with unequal interval width is possible.

References

Bartz, S. (2007). Excelblatt vereinfacht Stochastik. Stochastik in der Schule, 27(2), 25-29.

Beard, J. (2007). LAWTECH GURU BLOG. http://www.lawtechguru.com/archives/2007/09/25 excel 2007 multiplication math bug.html, 2008-01-28.

Borovcnik, M. (2007). Das Sammelbildproblem - Rosinen und Semmeln und Verwandtes: Eine rekursive Lösung mit Irrfahren. Stochastik in der Schule, 27(2), 19-24.

Casella, G., and Berger, R. (2002). Statistical Inference (2nd ed.). Pacific Grove, California: Duxbury.

Cleveland, W. (1994). The Elements of Graphing Data. Summit, New Jersey: Hobart Press.

Doane, D. (2004). Using Simulation to Teach Distributions. Journal of Statistics Education, 12(1).

European Commission. (2003). Commission Recommendation of 6 May 2003 concerning the definition of small and medium-sized enterprises. http://europa.eu/eurlex/pri/en/oj/dat/2003/l 124/l 12420030520en00360041.pdf, 2008-01-28.

Hafner, R., and Waldl, H. (2000). Statistik für Sozial- und Wirtschaftswissenschaftler, Band 2. Wien: Springer.

Heiser, D. (2006). Microsoft Excel 2000 and 2003 faults, problems, workarounds and fixes. Computational Statistics and Data Analysis, 51, 1442-1443.

Hogg, R., and Tanis, E. (2005). Probability and Statistical Inference (Seventh ed.). New York: Macmillan.

Horgan, G. (1999). Use of Spreadsheets for Demonstrating Experimental Power and Variability. Journal of Statistics Education, 7(1). http://www.stats.gla.ac.uk/steps/glossary/presenting data.html#hist. (2008-01-28).

Hunt, N. (1996). Spreadsheet Histograms. Teaching Statistics, 18(1), 10-11.

Hunt, N. (2003). Handling Continuous Data in Excel. Teaching Statistics, 25(2), 42-45.

Hunt, N. (2005). Using Microsoft Office to Generate Individualized Tasks for Students. Teaching Statistics, 27(2), 45-48.

Hunt, N. (2007). Individualized Statistics Coursework Using Spreadsheets. Teaching Statistics, 29(2), 38-43.

Hunt, N., and Mashhoudy, H. (2004). Charts in Excel – A Series Matter. Teaching Statistics, 26(2), 49-53.

Hyndman, R., and Fan, Y. (1996). Sample Quantiles in Statistical Packages. The American Statistician, 50(4), 361-365.

Johnson, R. (2004). Miller and Freund’s Probability and Statistics for Engineers. Upper Saddle River, New Jersey: Prentice Hall.

Keeling, K., and Pavur, R. (2007). A comparative study of the reliability of nine statistical software packages. Computational Statistics and Data Analysis, 51, 3811-3831.

Knüsel, L. (1998). On the Accuracy of Statistical Distributions in Microsoft Excel 97. Computational Statistics and Data Analysis, 26, 375-377.

Knüsel, L. (2005). On the accuracy of statistical distributions in Microsoft Excel 2003. Computational Statistics and Data Analysis, 48, 445-449.

Kühleitner, M. (2007). Sammelbildproblem: Eine Simulation mit Excel. Stochastik in der Schule, 27(1), 24-26.

Langford, E. (2006). Quartiles in Elementary Statisitcs. Journal of Statistics Education, 14.

Martin, C. (2007). A Simulation Based on Goldratt’s Matchstick/Die Game. Decision Sciences Journal of Innovative Education, 5(2), 423-429.

McCullough, B., and Wilson, B. (1999). On the accuracy of statistical procedures in Microsoft Excel 97. Computational Statistics and Data Analysis, 31, 27-37.

McCullough, B., and Wilson, B. (2002). On the accuracy of statistical procedures in Microsoft Excel 2000 and XP. Computational Statistics and Data Analysis, 40, 713-721.

McCullough, B., and Wilson, B. (2005). On the accuracy of statistical procedures in Microsoft Excel 2003. Computational Statistics and Data Analysis, 49, 1244-1252.

Microsoft. (2007). http://support.microsoft.com/kb/943075.

Mills, J. (2002). Computer Simulation Methods to teach Statistics: A Review of the Literature. Journal of Statistics Education, 10(1).

Nash, J., and Quon, T. (1996). Issues in Teaching Statistical Thinking with Spreadsheets. Journal of Statistics Education, 4(1).

Oliver, F. (1998). How to present information in graphs and diagrams. Notes on behalf of the Examinations Board of the Royal Statistical Society,

http://www.therss.org.uk/exams/docs/diagrams.pdf, 2008-01-28.

Price, B., and Zhang, X. (2007). The Power of Doing: A Learning Exercise that Brings the Central Limit Theorem to Life. Decision Sciences Journal of Innovative Education,

(2), 405-411.

Published
2016-04-03
How to Cite
Duller, C. (2016). Teaching Statistics with Excel A Big Challenge for Students and Lecturers. Austrian Journal of Statistics, 37(2), 195–206. https://doi.org/10.17713/ajs.v37i2.300
Section
Articles