摘要: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.
关键词:Spreadsheet, Frequency Distribution, Descriptive Statistics, Histogram.