Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Fwd: Dangers of using MS Excel for statistical work [SEC=UNCLASSIFIED]

From   Stas Kolenikov <>
To   "" <>,, AAPORnet <>
Subject   st: Fwd: Dangers of using MS Excel for statistical work [SEC=UNCLASSIFIED]
Date   Fri, 12 Apr 2013 11:04:00 -0500

Thought this would be useful to know. Background: NIST (National
Institute of Standards) provides a suite of tests
( that push the limits of
computational accuracy in routine statistical computation, e.g.,
having a regression model with a poorly conditioned matrix, or a
nonlinear regression problem with a sharp long ridge near the maximum
of the objective function that a poorly calibrated optimization
algorithm may miss. More serious software packages use these data sets
to gauge how they are doing against them
( but Excel developers seem
to be oblivious to these standards.

-- Stas Kolenikov, PhD, PStat (SSC)
-- Senior Survey Statistician, Abt SRBI
-- Opinions stated in this email are mine only, and do not reflect the
position of my employer

---------- Forwarded message ----------
From: Geoffrey Brent <>
Date: Fri, Apr 12, 2013 at 1:18 AM
Subject: Dangers of using MS Excel for statistical work  [SEC=UNCLASSIFIED]

Apologies if this has been circulated already and I missed it, but I
found this article about serious weaknesses in Excel's statistical
functionality rather alarming. This looks to go well beyond "rare bug"
type issues: for instance, when given 27 NIST standard test problems
on nonlinear least squares, it gave badly wrong answers for 11 (but
still claimed to have converged to a correct solution).

The article is based on Excel 2007, but it mentions that some of those
problems had been identified > 15 years earlier and remained unfixed.

Geoffrey Brent

Senior Research Officer

Business Survey Methodology  |  Statistical Services Branch |
Australian Bureau of Statistics

(P) (03) 9615 7685   (M) 0422 65 35 26

(E)  (W)


Free publications and statistics available on
*   For searches and help try:

© Copyright 1996–2015 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index