NDLI: On the accuracy of statistical procedures in Microsoft Excel 2010

Content Provider	Springer Nature Link
Author	Mélard, Guy
Copyright Year	2014
Abstract	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.
Starting Page	1095
Ending Page	1128
Page Count	34
File Format	PDF
ISSN	09434062
Journal	Computational Statistics
Volume Number	29
Issue Number	5
e-ISSN	16139658
Language	English
Publisher	Springer Berlin Heidelberg
Publisher Date	2014-04-10
Publisher Place	Berlin, Heidelberg
Access Restriction	One Nation One Subscription (ONOS)
Subject Keyword	Statistical function Random number generator Nonlinear regression OpenOffice.org Calc 3.3 Gnumeric Statistics Probability and Statistics in Computer Science Probability Theory and Stochastic Processes Economic Theory
Content Type	Text
Resource Type	Article
Subject	Statistics and Probability Statistics, Probability and Uncertainty Computational Mathematics

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

On the Numerical Accuracy of Spreadsheets

On the Numerical Accuracy of Spreadsheets

On the accuracy of statistical procedures in microsoft excel 2010.

e/csda On the accuracy of statistical procedures in Microsoft Excel 97 (1998)

e/csda On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP (2001)

Excel :: COM :: $$\mathsf{R}$$

Proceedings of Reisensburg 2010

Nonlinear regression modeling and detecting change points via the relevance vector machine

Bayesian inference using a noninformative prior for linear Gaussian random coefficient regression with inhomogeneous within-class variances

On the accuracy of statistical procedures in Microsoft Excel 2010

Similar Documents

On the Numerical Accuracy of Spreadsheets

On the Numerical Accuracy of Spreadsheets

On the accuracy of statistical procedures in microsoft excel 2010.

e/csda On the accuracy of statistical procedures in Microsoft Excel 97 (1998)

e/csda On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP (2001)

Excel :: COM :: $$\mathsf{R}$$

Proceedings of Reisensburg 2010

Nonlinear regression modeling and detecting change points via the relevance vector machine

Bayesian inference using a noninformative prior for linear Gaussian random coefficient regression with inhomogeneous within-class variances

On the accuracy of statistical procedures in Microsoft Excel 2010