On the accuracy of statistical procedures in Microsoft Excel 2010
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 update of these studies given the recent release of Excel 2010 and we have added OpenOffice.org Calc 3.3 and Gnumeric 1.10.16 to the analysis, for the purpose of comparison. The conclusion is that the stream of papers, mainly in Computational Statistics and Data Analysis, has started to pay off: Microsoft has partially improved the statistical aspects of Excel, essentially the statistical functions and the random number generator. Copyright Springer-Verlag Berlin Heidelberg 2014
Volume (Year): 29 (2014)
Issue (Month): 5 (October)
|Contact details of provider:|| Web page: http://www.springer.com|
|Order Information:||Web: http://www.springer.com/statistics/journal/180/PS2|
Please report citation or reference errors to , or , if you are the registered author of the cited work, log in to your RePEc Author Service profile, click on "citations" and make appropriate adjustments.:
- Thomas Herndon & Michael Ash & Robert Pollin, 2014.
"Does high public debt consistently stifle economic growth? A critique of Reinhart and Rogoff,"
Cambridge Journal of Economics,
Oxford University Press, vol. 38(2), pages 257-279.
- Thomas Herndon & Michael Ash & Robert Pollin, 2013. "Does High Public Debt Consistently Stifle Economic Growth? A Critique of Reinhart and Rogo ff," Working Papers wp322, Political Economy Research Institute, University of Massachusetts at Amherst.
- A. Yalta & A. Yalta, 2010. "Should Economists Use Open Source Software for Doing Research?," Computational Economics, Springer;Society for Computational Economics, vol. 35(4), pages 371-394, April.
- A. Talha Yalta & A. Yasemin Yalta, 2010. "Should Economists Use Open Source Software for Doing Research?," Working Papers 1007, TOBB University of Economics and Technology, Department of Economics.
- A. Talha Yalta & A. Yasemin Yalta, 2012. "Should Economists Use Open Source Software for Doing Research?," Hacettepe University Department of Economics Working Papers 20127, Hacettepe University, Department of Economics.
- McCullough, Bruce D. & Yalta, A. Talha, 2013. "Spreadsheets in the Cloud - Not Ready Yet," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 52(i07).
- Koenker,Roger, 2005. "Quantile Regression," Cambridge Books, Cambridge University Press, number 9780521845731, February.
- Roger Koenker & Kevin F. Hallock, 2001. "Quantile Regression," Journal of Economic Perspectives, American Economic Association, vol. 15(4), pages 143-156, Fall.
- Koenker,Roger, 2005. "Quantile Regression," Cambridge Books, Cambridge University Press, number 9780521608275.
- A. Talha Yalta, 2010. "The Accuracy of Statistical Distributions in Microsoft (R) Excel 2007," Working Papers 1006, TOBB University of Economics and Technology, Department of Economics.
- Yalta, A. Talha & Jenal, Olaf, 2009. "On the importance of verifying forecasting results," International Journal of Forecasting, Elsevier, vol. 25(1), pages 62-73.
- A. Talha Yalta & Olaf Jenal, 2008. "On the Importance of Verifying Forecasting Results," Working Papers 0804, TOBB University of Economics and Technology, Department of Economics.
- D. McCullough, B. & Wilson, Berry, 2002. "On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP," Computational Statistics & Data Analysis, Elsevier, vol. 40(4), pages 713-721, October.
- Hargreaves, Bruce R. & McWilliams, Thomas P., 2010. "Polynomial Trendline function flaws in Microsoft Excel," Computational Statistics & Data Analysis, Elsevier, vol. 54(4), pages 1190-1196, April.
- Sawitzki, Gunther, 1994. "Report on the Numerical Reliability of Data Analysis Systems," Computational Statistics & Data Analysis, Elsevier, vol. 18(2), pages 289-301, September.
- B. D. McCullough, 2006. "A review of TESTU01," Journal of Applied Econometrics, John Wiley & Sons, Ltd., vol. 21(5), pages 677-682. Full references (including those not matched with items on IDEAS)
When requesting a correction, please mention this item's handle: RePEc:spr:compst:v:29:y:2014:i:5:p:1095-1128. See general information about how to correct material in RePEc.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Sonal Shukla)or (Rebekah McClure)
If references are entirely missing, you can add them using this form.