On the accuracy of statistical procedures in Microsoft Excel 2010

@article{Mlard2014OnTA,
  title={On the accuracy of statistical procedures in Microsoft Excel 2010},
  author={G. M{\'e}lard},
  journal={Computational Statistics},
  year={2014},
  volume={29},
  pages={1095-1128}
}
  • G. Mélard
  • Published 2014
  • Computer Science
  • Computational Statistics
  • All previous versions of Microsoft Excel until Excel 2007 have been criticized by statisticians for several reasons, including the accuracy of statistical functions, the properties of the random number generator, the quality of statistical add-ins, the weakness of the Solver for nonlinear regression, and the data graphical representation. Until recently Microsoft did not make an attempt to fix all the errors in Excel and was still marketing a product that contained known errors. We provide an… CONTINUE READING
    44 Citations
    Microsoft EXCEL 2010 offers an improved random number generator allowing efficient simulation in chemical laboratory studies.
    • A. Kallner
    • Computer Science, Medicine
    • Clinica chimica acta; international journal of clinical chemistry
    • 2015
    • 6
    Assessing Excel VBA Suitability for Monte Carlo Simulation
    • 4
    • PDF
    On the accuracy of linear regression routines in some data mining packages
    • 2
    Excel Templates: A Helpful Tool for Teaching Statistics
    • 4
    Resampling methods in Microsoft Excel® for estimating reference intervals
    • 2
    • PDF
    Estimating the Accuracy of the Return on Investment (ROI) Performance Evaluations
    • 3
    • PDF

    References

    SHOWING 1-10 OF 65 REFERENCES
    On the accuracy of statistical procedures in Microsoft Excel 2007
    • 127
    • PDF
    The accuracy of statistical distributions in Microsoft® Excel 2007
    • A. Yalta
    • Mathematics, Computer Science
    • Comput. Stat. Data Anal.
    • 2008
    • 54
    • Highly Influential
    • PDF
    Statistical Accuracy of Spreadsheet Software
    • 28
    On the accuracy of statistical procedures in Microsoft Excel 2003
    • 219
    Polynomial Trendline function flaws in Microsoft Excel
    • 16
    • PDF
    On the Numerical Accuracy of Spreadsheets
    • 21
    • Highly Influential
    • PDF
    Nonstandard operator precedence in Excel
    • R. Berger
    • Mathematics, Computer Science
    • Comput. Stat. Data Anal.
    • 2007
    • 11
    • Highly Influential
    On the accuracy of statistical distributions in Microsoft Excel 2003
    • Leo Kn usel
    • 1998
    • 29
    • Highly Influential
    • PDF
    Assessing the Reliability of Statistical Software: Part I
    • 164
    • Highly Influential
    • PDF