Statistical Analysis with a Spreadsheet: A Comparison of Software

Abstract

Undertakes a comparative study of the statistical capability of three spreadsheets which are commonly used in the business sector. The spreadsheets considered are Lotus 1‐2‐3, Microsoft Excel and Quattro Pro. Considers five areas of statistical analysis regularly used by business decision makers (rather than specialist personnel). In order to obtain an objective measure of the statistical provision of each spreadsheet, comparison has also been made with dedicated statistical software regularly used by business decision makers, namely MINITAB. By making this comparison, argues that the spreadsheet is not only a tool for analysis, but also for presentation. Moreover, considers that two spreadsheets in particular, namely Excel and Quattro Pro, offer a user‐friendly statistical provision which should be sufficient for most business decision makers.

Citation

Robson, A. (1994), "Statistical Analysis with a Spreadsheet: A Comparison of Software", Logistics Information Management, Vol. 7 No. 2, pp. 12-17. https://doi.org/10.1108/09576059410057156