Editing Microsoft Excel (section)

=== Statistical functions ===
The accuracy and convenience of statistical tools in Excel has been criticized,<ref>{{cite journal|last=McCullough|first=Bruce D.|author2=Wilson, Berry|title=On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP|journal=Computational Statistics & Data Analysis|year=2002|volume=40|issue=4|pages=713–721|doi=10.1016/S0167-9473(02)00095-6}}</ref><ref>{{cite journal|last=McCullough|first=Bruce D.|author2=Heiser, David A.|title=On the accuracy of statistical procedures in Microsoft Excel 2007|journal=Computational Statistics & Data Analysis|year=2008|volume=52|issue=10|pages=4570–4578|doi=10.1016/j.csda.2008.03.004|citeseerx=10.1.1.455.5508}}</ref><ref>{{cite journal|last=Yalta|first=A. Talha|title=The accuracy of statistical distributions in Microsoft Excel 2007|journal=Computational Statistics & Data Analysis|year=2008|volume=52|issue=10|pages=4579–4586|doi=10.1016/j.csda.2008.03.005}}</ref><ref>{{cite web|url=http://www-unix.oit.umass.edu/~evagold/excel.html|title=Using Excel for Statistical Data Analysis—Caveats|publisher=University of Massachusetts School of Public Health|last=Goldwater|first=Eva|access-date=November 10, 2008|archive-date=May 16, 2008|archive-url=https://web.archive.org/web/20080516091435/http://www-unix.oit.umass.edu/%7Eevagold/excel.html|url-status=live}}</ref><ref name="Heiser">
{{cite web|url=http://www.daheiser.info/excel/frontpage.html|title=Microsoft Excel 2000, 2003 and 2007 faults, problems, workarounds and fixes|first=David A.|last=Heiser|year=2008|access-date=April 8, 2010|url-status=dead|archive-url=https://web.archive.org/web/20100418172334/http://www.daheiser.info/excel/frontpage.html|archive-date=April 18, 2010}}
</ref> as mishandling situations when data is missing, as returning incorrect values due to inept handling of round-off and large numbers, as only selectively updating calculations on a spreadsheet when some cell values are changed, and as having a limited set of statistical tools. Microsoft has announced that some of these issues are addressed in Excel 2010.<ref name="corrections">
[http://blogs.msdn.com/excel/archive/2009/09/10/function-improvements-in-excel-2010.aspx Function improvements in Excel 2010] {{webarchive|url=https://web.archive.org/web/20100406191751/http://blogs.msdn.com/excel/archive/2009/09/10/function-improvements-in-excel-2010.aspx |date=April 6, 2010 }} Comments are provided from readers that may illuminate some remaining problems.
</ref>