Article: The numerical accuracy of statistical calculations in Excel 2000 and Minitab Version 13 Journal: Journal of Business and Management (JBM) 2002 Vol.8 No.2 pp.199 - 207 Abstract: Certain statistical procedures available in Excel 2000 and Minitab Version 13 are assessed for their numerical reliability. Both Excel and Minitab are widely used in teaching as well as in industry for statistical analysis, so numerical accuracy is important. Minitab is very accurate in the three areas tested: computing univariate statistics, regression, and anova. Excel has shortcomings of which users should be aware. Comparisons are also made to results from previous research on SAS and SPSS. Minitab compares favorably to both these statistical packages. Inderscience Publishers - linking academia, business and industry through research

Title: The numerical accuracy of statistical calculations in Excel 2000 and Minitab Version 13

Authors: Terry E. Dielman

Addresses: Author address listing can be found in the "About the Authors" section at the end of the article.

Abstract: Certain statistical procedures available in Excel 2000 and Minitab Version 13 are assessed for their numerical reliability. Both Excel and Minitab are widely used in teaching as well as in industry for statistical analysis, so numerical accuracy is important. Minitab is very accurate in the three areas tested: computing univariate statistics, regression, and anova. Excel has shortcomings of which users should be aware. Comparisons are also made to results from previous research on SAS and SPSS. Minitab compares favorably to both these statistical packages.

Keywords: Numerical accuracy; statistical calculations; excel 2000; Minitab 13; software comparison.

DOI: 10.1504/JBM.2002.141084

Journal of Business and Management, 2002 Vol.8 No.2, pp.199 - 207

Published online: 05 Sep 2024 *

Title: The numerical accuracy of statistical calculations in Excel 2000 and Minitab Version 13

Keep up-to-date