{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,11]],"date-time":"2026-02-11T14:59:09Z","timestamp":1770821949775,"version":"3.50.1"},"reference-count":56,"publisher":"Springer Science and Business Media LLC","issue":"5","license":[{"start":{"date-parts":[[2014,4,10]],"date-time":"2014-04-10T00:00:00Z","timestamp":1397088000000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Comput Stat"],"published-print":{"date-parts":[[2014,10]]},"DOI":"10.1007\/s00180-014-0482-5","type":"journal-article","created":{"date-parts":[[2014,4,9]],"date-time":"2014-04-09T04:55:40Z","timestamp":1397019340000},"page":"1095-1128","source":"Crossref","is-referenced-by-count":58,"title":["On the accuracy of statistical procedures in Microsoft Excel 2010"],"prefix":"10.1007","volume":"29","author":[{"given":"Guy","family":"M\u00e9lard","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2014,4,10]]},"reference":[{"issue":"4","key":"482_CR1","doi-asserted-by":"crossref","first-page":"1","DOI":"10.18637\/jss.v034.i04","volume":"34","author":"MG Almiron","year":"2010","unstructured":"Almiron MG, Lopes B, Oliveira ALC, Medeiros AC, Frery AC (2010) On the numerical accuracy of spreadsheets. J Stat Softw 34(4):1\u201329","journal-title":"J Stat Softw"},{"key":"482_CR2","unstructured":"Bailey DH (1993) A portable high performance multiprecision package. RNR technical report 90\u2013022, NASA Ames Research Center, Moffett Field, Calif."},{"key":"482_CR3","doi-asserted-by":"crossref","first-page":"2788","DOI":"10.1016\/j.csda.2006.09.040","volume":"51","author":"RL Berger","year":"2007","unstructured":"Berger RL (2007) Nonstandard operator precedence in Excel. Comput Stat Data Anal 51:2788\u20132791","journal-title":"Comput Stat Data Anal"},{"key":"482_CR4","volume-title":"The elements of graphing data","author":"W Cleveland","year":"1994","unstructured":"Cleveland W (1994) The elements of graphing data, 2nd edn. Hobart Press, Summit, NJ","edition":"2"},{"key":"482_CR5","unstructured":"Crabtree C (2009) How random is random. http:\/\/cliffcrabtree.net\/randomarticle.html . Accessed 4 Feb 2014"},{"key":"482_CR6","unstructured":"Cryer JD (2001) Problems with using Microsoft Excel for statistics. In: Proceedings of the joint statistical meetings. American Statistical Association, Atlanta."},{"key":"482_CR7","unstructured":"European Spreadsheet Risks Interest Group (2013) http:\/\/www.eusprig.org\/index.htm . Accessed 29 Jan 2014"},{"key":"482_CR8","doi-asserted-by":"crossref","first-page":"29","DOI":"10.1287\/inte.28.5.29","volume":"28","author":"D Fylstra","year":"1998","unstructured":"Fylstra D, Lasdon L, Watson J, Waren AD (1998) Design and use of the Microsoft Excel Solver. Interfaces 28:29\u201355","journal-title":"Interfaces"},{"key":"482_CR9","first-page":"1942","volume":"30","author":"LJ Guibas","year":"1981","unstructured":"Guibas LJ, Odlyzko AM (1981) Periods in strings. J Comb Theory A 30:1942","journal-title":"J Comb Theory A"},{"key":"482_CR10","doi-asserted-by":"crossref","first-page":"1190","DOI":"10.1016\/j.csda.2009.10.020","volume":"54","author":"BR Hargreaves","year":"2010","unstructured":"Hargreaves BR, McWilliams TP (2010) Polynomial trendline function flaws in Microsoft Excel. Comput Stat Data Anal 54:1190\u20131196","journal-title":"Comput Stat Data Anal"},{"key":"482_CR11","unstructured":"Heiser DA (2009) Microsoft Excel 2000, 2003 and 2007 faults, problems, workarounds and fixes. http:\/\/www.daheiser.info\/excel\/frontpage.html . Accessed 26 Feb 2013"},{"key":"482_CR12","doi-asserted-by":"crossref","unstructured":"Herndon T, Ash M. Pollin R (2013) Does high public debt consistently stifle economic growth? A critique of Reinhart and Rogoff. PERI working paper no. 322, April, University of Massachusetts Amherst.","DOI":"10.1093\/cje\/bet075"},{"key":"482_CR13","unstructured":"H\u00fcmmer T (2010) International OpenOffice market shares. http:\/\/www.webmasterpro.de\/portal\/news\/2010\/02\/05\/international-openoffice-market-shares.html . Accessed 29 Jan 2014"},{"key":"482_CR14","unstructured":"IBM (2010) The risks of using spreadsheets for statistical analysis. IBM software business analytics, Somers. http:\/\/public.dhe.ibm.com\/common\/ssi\/ecm\/en\/ytw03240usen\/YTW03240USEN.PDF . Accessed 29 Jan 2014"},{"key":"482_CR15","doi-asserted-by":"crossref","first-page":"265","DOI":"10.1198\/tas.2011.09076","volume":"65","author":"KB Keeling","year":"2011","unstructured":"Keeling KB, Pavur RJ (2011) Statistical accuracy of spreadsheet software. Am Stat 65:265\u2013273","journal-title":"Am Stat"},{"key":"482_CR16","doi-asserted-by":"crossref","first-page":"375","DOI":"10.1016\/S0167-9473(97)81756-2","volume":"26","author":"L Kn\u00fcsel","year":"1998","unstructured":"Kn\u00fcsel L (1998) On the accuracy of statistical distributions in Microsoft Excel 97. Comput Stat Data Anal 26:375\u2013377","journal-title":"Comput Stat Data Anal"},{"key":"482_CR17","unstructured":"Kn\u00fcsel L (2003) Computation of statistical distributions\u2013documentation of program ELV, 2nd edn. http:\/\/www.statistik.lmu.de\/ knuesel. Accessed 26 Feb 2013"},{"key":"482_CR18","doi-asserted-by":"crossref","first-page":"445","DOI":"10.1016\/j.csda.2004.02.008","volume":"48","author":"L Kn\u00fcsel","year":"2005","unstructured":"Kn\u00fcsel L (2005) On the accuracy of statistical distributions in Microsoft Excel 2003. Comput Stat Data Anal 48:445\u2013449","journal-title":"Comput Stat Data Anal"},{"key":"482_CR19","unstructured":"Kn\u00fcsel L (2011) On the accuracy of statistical distributions in Microsoft Excel 2010. http:\/\/www.csdassn.org\/software_reports\/Excel2011.pdf . Accessed 29 Jan 2014"},{"key":"482_CR20","doi-asserted-by":"crossref","DOI":"10.1017\/CBO9780511754098","volume-title":"Quantile regression","author":"R Koenker","year":"2005","unstructured":"Koenker R (2005) Quantile regression. Cambridge University Press, Cambridge"},{"key":"482_CR21","doi-asserted-by":"crossref","first-page":"34","DOI":"10.1145\/355769.355773","volume":"4","author":"LS Lasdon","year":"1978","unstructured":"Lasdon LS, Waren AD, Jain A, Ratner M (1978) Design and testing of a generalized reduced gradient code for nonlinear programming. ACM Trans Math Softw 4:34\u201350","journal-title":"ACM Trans Math Softw"},{"issue":"22","key":"482_CR22","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1145\/1268776.1268777","volume":"33","author":"P L\u2019Ecuyer","year":"2007","unstructured":"L\u2019Ecuyer P, Simard R (2007) TESTU01: A C library for empirical testing of random number generators. ACM Trans Math Softw 33(22):1\u201340","journal-title":"ACM Trans Math Softw"},{"key":"482_CR23","unstructured":"L\u2019Ecuyer P, Simard R (2009) TestU01: A software library in ANSI C for empirical testing of random number generators. User\u2019s guide, compact version. http:\/\/www.iro.umontreal.ca\/ $$\\sim $$ \u223c lecuyer\/. Accessed 29 Jan 2014"},{"key":"482_CR24","unstructured":"Lewis JW (2005). https:\/\/groups.google.com\/forum\/#!msg\/microsoft.public.excel\/n4PKPeo45QE\/9a8eXXiV-24J . Accessed 4 Feb 2014"},{"key":"482_CR25","doi-asserted-by":"crossref","first-page":"3","DOI":"10.1145\/272991.272995","volume":"8","author":"M Matsumoto","year":"1998","unstructured":"Matsumoto M, Nishimura T (1998) Mersenne Twister: a 623-dimensionally equidistributed uniform pseudorandom number generator. ACM Trans Model Comput Simul 8:3\u201330","journal-title":"ACM Trans Model Comput Simul"},{"key":"482_CR26","doi-asserted-by":"crossref","first-page":"358","DOI":"10.1080\/00031305.1998.10480597","volume":"52","author":"BD McCullough","year":"1998","unstructured":"McCullough BD (1998) Assessing the reliability of statistical software: part I. Am Stat 52:358\u2013366","journal-title":"Am Stat"},{"key":"482_CR27","doi-asserted-by":"crossref","first-page":"149","DOI":"10.1080\/00031305.1999.10474450","volume":"53","author":"BD McCullough","year":"1999","unstructured":"McCullough BD (1999) Assessing the reliability of statistical software: part II. Am Stat 53:149\u2013159","journal-title":"Am Stat"},{"key":"482_CR28","doi-asserted-by":"crossref","first-page":"279","DOI":"10.1007\/s001800050008","volume":"15","author":"BD McCullough","year":"2000","unstructured":"McCullough BD (2000) The accuracy of Mathematica 4 as a statistical package. Comput Stat 15:279\u2013299","journal-title":"Comput Stat"},{"key":"482_CR29","doi-asserted-by":"crossref","first-page":"199","DOI":"10.1002\/0471475769.ch8","volume-title":"Numerical issues in statistical computing for the social scientist, Chapter 8","author":"BD McCullough","year":"2004","unstructured":"McCullough BD (2004a) Some details of nonlinear estimation. In: Altman M, Gill J, McDonald MP (eds) Numerical issues in statistical computing for the social scientist, Chapter 8 . Wiley, New York, pp 199\u2013218"},{"key":"482_CR30","doi-asserted-by":"crossref","first-page":"261","DOI":"10.3233\/JEM-2004-0199","volume":"29","author":"BD McCullough","year":"2004","unstructured":"McCullough BD (2004b) Wilkinson\u2019s tests and econometric software. J Econ Soc Meas 29:261\u2013270","journal-title":"J Econ Soc Meas"},{"key":"482_CR31","unstructured":"McCullough BD (2004c) Fixing statistical errors in spreadsheet software: the cases of Gnumeric and Excel. CSDA Statistical Software Newsletter. www.csdassn.org\/software_reports.cfm."},{"key":"482_CR32","doi-asserted-by":"crossref","first-page":"677","DOI":"10.1002\/jae.917","volume":"21","author":"BD McCullough","year":"2006","unstructured":"McCullough BD (2006) A review of TESTU01. J Appl Econ 21:677\u2013682","journal-title":"J Appl Econ"},{"key":"482_CR33","doi-asserted-by":"crossref","first-page":"4568","DOI":"10.1016\/j.csda.2008.03.009","volume":"52","author":"BD McCullough","year":"2008","unstructured":"McCullough BD (2008a) Editorial: special section on Microsoft Excel 2007. Comput Stat Data Anal 52:4568\u20134569","journal-title":"Comput Stat Data Anal"},{"key":"482_CR34","doi-asserted-by":"crossref","first-page":"4587","DOI":"10.1016\/j.csda.2008.03.006","volume":"52","author":"BD McCullough","year":"2008","unstructured":"McCullough BD (2008b) Microsoft Excel 2007\u2019s \u2019Not the Wichmann-Hill\u2019 random number generator. Comput Stat Data Anal 52:4587\u20134593","journal-title":"Comput Stat Data Anal"},{"key":"482_CR35","doi-asserted-by":"crossref","first-page":"27","DOI":"10.1016\/S0167-9473(99)00004-3","volume":"31","author":"BD McCullough","year":"1999","unstructured":"McCullough BD, Wilson B (1999) On the accuracy of statistical procedures in Microsoft Excel 97. Comput Stat Data Anal 31:27\u201337","journal-title":"Comput Stat Data Anal"},{"key":"482_CR36","doi-asserted-by":"crossref","first-page":"63","DOI":"10.3233\/JEM-2000-0177","volume":"26","author":"BD McCullough","year":"2000","unstructured":"McCullough BD, Renfro CR (2000) Some numerical aspects of nonlinear estimation. J Econ Soc Meas 26:63\u201377","journal-title":"J Econ Soc Meas"},{"key":"482_CR37","doi-asserted-by":"crossref","first-page":"713","DOI":"10.1016\/S0167-9473(02)00095-6","volume":"40","author":"BD McCullough","year":"2002","unstructured":"McCullough BD, Wilson B (2002) On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP. Comput Stat Data Anal 40:713\u2013721","journal-title":"Comput Stat Data Anal"},{"key":"482_CR38","doi-asserted-by":"crossref","first-page":"1244","DOI":"10.1016\/j.csda.2004.06.016","volume":"49","author":"BD McCullough","year":"2005","unstructured":"McCullough BD, Wilson B (2005) On the accuracy of statistical procedures in Microsoft Excel 2003. Comput Stat Data Anal 49:1244\u20131252","journal-title":"Comput Stat Data Anal"},{"key":"482_CR39","doi-asserted-by":"crossref","first-page":"4570","DOI":"10.1016\/j.csda.2008.03.004","volume":"52","author":"BD McCullough","year":"2008","unstructured":"McCullough BD, Heiser DA (2008) On the accuracy of statistical procedures in Microsoft Excel 2007. Comput Stat Data Anal 52:4570\u20134578","journal-title":"Comput Stat Data Anal"},{"issue":"7","key":"482_CR40","doi-asserted-by":"crossref","first-page":"1","DOI":"10.18637\/jss.v052.i07","volume":"52","author":"BD McCullough","year":"2013","unstructured":"McCullough BD, Yalta AT (2013) Spreadsheets in the cloud\u2013not ready yet. J Stat Softw 52(7):1\u201314","journal-title":"J Stat Softw"},{"key":"482_CR41","unstructured":"Microsoft (2009a) Function improvements in Microsoft Excel 2010, White paper. http:\/\/blogs.office.com\/cfs-filesystemfile.ashx\/__key\/CommunityServer-Components-PostAttachments\/00-00-00-49-53\/ExcelFunctionImprovements-10_2D00_05_2D00_09-_2800_1_2900_ . Accessed 26 Feb 2013"},{"key":"482_CR42","unstructured":"Microsoft (2009b) About Solver. http:\/\/office.microsoft.com\/en-us\/excel-help\/about-solver-HP005198368.aspx?pid=CH010004571033 . Accessed 29 Jan 2014"},{"key":"482_CR43","unstructured":"Microsoft (2013) Changes in Office 2013. http:\/\/technet.microsoft.com\/en-us\/library\/cc178954.aspx . Accessed 29 Jan 2014"},{"key":"482_CR44","unstructured":"Oppenheimer DM (2009) Function improvements in Excel 2010. http:\/\/blogs.msdn.com\/b\/excel\/archive\/2009\/09\/10\/function-improvements-in-excel-2010.aspx . Accessed 29 Jan 2014"},{"key":"482_CR45","doi-asserted-by":"crossref","first-page":"573","DOI":"10.1257\/aer.100.2.573","volume":"100","author":"CM Reinhart","year":"2010","unstructured":"Reinhart CM, Rogoff KS (2010) Growth in a time of debt. Am Econ Rev 100:573\u2013578","journal-title":"Am Econ Rev"},{"key":"482_CR46","first-page":"27","volume":"39","author":"AHG Rinnooy-Kan","year":"1987","unstructured":"Rinnooy-Kan AHG, Timmer GT (1987a) Stochastic global optimization methods. Part I: clustering methods. Math Program 39:27\u201356","journal-title":"Part I: clustering methods. Math Program"},{"key":"482_CR47","doi-asserted-by":"crossref","first-page":"57","DOI":"10.1007\/BF02592071","volume":"39","author":"AHG Rinnooy-Kan","year":"1987","unstructured":"Rinnooy-Kan AHG, Timmer GT (1987b) Stochastic global optimization methods. Part II: multi level methods. Math Program 39:57\u201378","journal-title":"Math Program"},{"key":"482_CR48","doi-asserted-by":"crossref","first-page":"289","DOI":"10.1016\/0167-9473(94)90177-5","volume":"18","author":"G Sawitzki","year":"1994","unstructured":"Sawitzki G (1994) Report on the numerical reliability of data analysis systems. Comput Stat Data Anal 18:289\u2013301","journal-title":"Comput Stat Data Anal"},{"key":"482_CR49","unstructured":"Simon G (2000) Excel produces numerically inaccurate results. https:\/\/www.jiscmail.ac.uk\/cgi-bin\/wa.exe?A2=ind0012&L=ASSUME&F=&S=&X=31BDFD6E4E1E0E4F11&P=4325 . Accessed 5 Sept 2010 (Online resource 1)"},{"key":"482_CR50","doi-asserted-by":"crossref","first-page":"4594","DOI":"10.1016\/j.csda.2008.03.007","volume":"52","author":"Y-S Su","year":"2008","unstructured":"Su Y-S (2008) It\u2019s easy to produce chartjunk using Microsoft Excel 2007 but hard to make good graphs. Comput Stat Data Anal 52:4594\u20134601","journal-title":"Comput Stat Data Anal"},{"key":"482_CR51","volume-title":"The visual display of quantitative information","author":"ER Tufte","year":"1983","unstructured":"Tufte ER (1983) The visual display of quantitative information. Graphic Press, Cheshire"},{"key":"482_CR52","volume-title":"Excel 2007 charts","author":"J Walkenbach","year":"2007","unstructured":"Walkenbach J (2007) Excel 2007 charts. Wiley, New York"},{"key":"482_CR53","volume-title":"Applied statistics algorithms","author":"BA Wichmann","year":"1985","unstructured":"Wichmann BA (1985) Hill ID (1982) Algorithm AS 183: an efficient and portable pseudo-random number generator. J R Statist Soc Ser C Appl Stat 31:188\u2013190. Reprinted with correction. In: Hill ID, Griffith P (eds) Applied statistics algorithms. Ellis Horwood, Chichester"},{"key":"482_CR54","doi-asserted-by":"crossref","first-page":"4579","DOI":"10.1016\/j.csda.2008.03.005","volume":"52","author":"AT Yalta","year":"2008","unstructured":"Yalta AT (2008) The accuracy of statistical distributions in Microsoft Excel 2007. Comput Stat Data Anal 52:4579\u20134586","journal-title":"Comput Stat Data Anal"},{"key":"482_CR55","doi-asserted-by":"crossref","first-page":"62","DOI":"10.1016\/j.ijforecast.2008.07.002","volume":"25","author":"AT Yalta","year":"2009","unstructured":"Yalta AT, Jenal O (2009) On the importance of verifying forecasting results. Int J Forecast 25:62\u201373","journal-title":"Int J Forecast"},{"key":"482_CR56","doi-asserted-by":"crossref","first-page":"371","DOI":"10.1007\/s10614-010-9204-4","volume":"35","author":"AT Yalta","year":"2010","unstructured":"Yalta AT, Yalta AY (2010) Should economists use open source software for doing research? Comput Econ 35:371\u2013394","journal-title":"Comput Econ"}],"container-title":["Computational Statistics"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s00180-014-0482-5.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s00180-014-0482-5\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s00180-014-0482-5","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,5,25]],"date-time":"2024-05-25T19:36:50Z","timestamp":1716665810000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s00180-014-0482-5"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2014,4,10]]},"references-count":56,"journal-issue":{"issue":"5","published-print":{"date-parts":[[2014,10]]}},"alternative-id":["482"],"URL":"https:\/\/doi.org\/10.1007\/s00180-014-0482-5","relation":{},"ISSN":["0943-4062","1613-9658"],"issn-type":[{"value":"0943-4062","type":"print"},{"value":"1613-9658","type":"electronic"}],"subject":[],"published":{"date-parts":[[2014,4,10]]}}}