Teaching Statistics with Excel A Big Challenge for Students and Lecturers
DOI:
https://doi.org/10.17713/ajs.v37i2.300Abstract
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.
Downloads
Published
How to Cite
Issue
Section
License
The Austrian Journal of Statistics publish open access articles under the terms of the Creative Commons Attribution (CC BY) License.
The Creative Commons Attribution License (CC-BY) allows users to copy, distribute and transmit an article, adapt the article and make commercial use of the article. The CC BY license permits commercial and non-commercial re-use of an open access article, as long as the author is properly attributed.
Copyright on any research article published by the Austrian Journal of Statistics is retained by the author(s). Authors grant the Austrian Journal of Statistics a license to publish the article and identify itself as the original publisher. Authors also grant any third party the right to use the article freely as long as its original authors, citation details and publisher are identified.
Manuscripts should be unpublished and not be under consideration for publication elsewhere. By submitting an article, the author(s) certify that the article is their original work, that they have the right to submit the article for publication, and that they can grant the above license.