Teaching Statistics with Excel A Big Challenge for Students and Lecturers

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.