On the accuracy of statistical distributions in Microsoft Excel 97
Computational Statistics & Data Analysis
On the accuracy of statistical procedures in microsoft Excel 2000 and Excel XP
Computational Statistics & Data Analysis
Numerical accuracy issues in using Excel for simulation studies
WSC '04 Proceedings of the 36th conference on Winter simulation
The accuracy of statistical distributions in Microsoft®Excel 2007
Computational Statistics & Data Analysis
Should Economists Use Open Source Software for Doing Research?
Computational Economics
Hi-index | 0.03 |
The paper deals with the reliability of Microsoft Excel XP for statistical purposes. In section 1 we show that Excel can compute negative variances. In section 2 we see that the random numbers generated by Excel cannot suffice scientific statistical requirements, and in section 3 we have to report that unbearable errors with the computation of statistical distributions that have been reported to Microsoft and later on have been published (Knüsel, 1998) are still to be found in Microsoft Excel XP. So one has again to warn the scientific community against using Microsoft Excel for statistical purposes.