Open AccessTeaching Statistics with Excel A Big Challenge for Students and Lecturers
Author(s) -
Christine Duller
Publication year - 2016
Publication title -
österreichische zeitschrift für statistik
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.342
H-Index - 9
ISSN - 1026-597X
DOI - 10.17713/ajs.v37i2.300
Subject(s) - computer science , section (typography) , microsoft excel , point (geometry) , computational statistics , ms excel , histogram , interval (graph theory) , data science , statistics , software engineering , mathematics , artificial intelligence , machine learning , operating system , geometry , image (mathematics) , combinatorics
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.