Article Abstract

Basic statistics with Microsoft Excel: a review

Authors: Duilio Divisi, Gabriella Di Leonardo, Gino Zaccagna, Roberto Crisci

Abstract

The scientific world is enriched daily with new knowledge, due to new technologies and continuous discoveries. The mathematical functions explain the statistical concepts particularly those of mean, median and mode along with those of frequency and frequency distribution associated to histograms and graphical representations, determining elaborative processes on the basis of the spreadsheet operations. The aim of the study is to highlight the mathematical basis of statistical models that regulate the operation of spreadsheets in Microsoft Excel.