statrefs home‎ > ‎Main‎ > ‎Software‎ > ‎

Microsoft Excel


 
OK ... what about Microsoft Excel (or similar spreadsheet applications)?  Should it be included on a list of statistical software packages?
  • Related:


This is debatable. 
  • Certainly Excel (and other spreadsheet applications) includes some functionality for statistical methods, and there are several packages that are add-ons that are available commercially.  (See QI Macros
  • Having admitted this, I will also note that it is very easy to mis-use the statistical functionality offered in a spreadsheet package ... easier, perhaps, then it is to mis-use functionality offered in a statistical software package.  I have personally witnessed a Ph.D. (in a physical science) inappropriately use the formula for calculating the standard deviation of a population when the appropriate function would have been the standard deviation of a sample.  This is only one of many examples of misuse due to misunderstanding of the tool and its limitations.  When using more advanced methods (regression, ANOVA), it becomes even easier to mis-use a spreadsheet application. 
  • I have noticed that those who typically use spreadsheet applications for statistical analysis usually fail to perform and report diagnostic tests to check the assumptions of their model and its statistical method(s).
  • There are also computational issues that a user of any such application needs to be aware of.  The articles below discuss many of these issues.


Included below are various links to articles that discuss this topic.
  • Paper on "Spreadsheet Addiction" by Patrick Burns that nicely outlines many of the pitfalls of using spreadsheets in applications perhaps better suited to other types of software packages.
  • Paper by IBM - SPSS (attached at the bottom of this page; also here) entitled "The Risks of Using Spreadsheets for Statistical Analysis"
  • Why R is Better Than Excel for Fantasy Football (and most other) Data Analysis (http://is.gd/f4g07D)



An interesting discussion thread with several useful references is available in a LinkedIn Group. 



Interesting Excel add-ins:

Sparklines (http://sparklines-excel.blogspot.ie/)

PowerPivot (http://www.microsoft.com/en-us/bi/powerpivot.aspx)

BeGraphic (http://www.begraphic.com/)




 
Subpages (1): Excel Tricks
Ċ
Clifford Long,
Jun 17, 2011, 3:55 AM
Comments