Polynomial trendline function flaws in Microsoft Excel

DOI10.1016/J.CSDA.2009.10.020MaRDI QIDQ962373zbMATH OpenOpenAlexFDO

Authors Bruce R. Hargreaves, Thomas P. McWilliams

Publication date 6 April 2010

Published in Computational Statistics and Data Analysis (Search for Journal in Brave)

Full work available at URL https://doi.org/10.1016/j.csda.2009.10.020

Mathematics Subject Classification ID

Software, source code, etc. for problems pertaining to statistics (62-04)

Recommendations

• On the accuracy of statistical procedures in Microsoft Excel 2007
• On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP.
• On the accuracy of statistical procedures in Microsoft Excel 2003
• On the accuracy of statistical distributions in Microsoft Excel 2003
• On the accuracy of statistical procedures in Microsoft Excel 2010

Cites work

• Editorial: Special section on Microsoft Excel 2007
• It's easy to produce Chartjunk using Microsoft\(^{\circledR}\) Excel 2007 but hard to make good graphs
• Microsoft Excel's `Not the Wichmann-Hill' random number generators
• On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP.
• On the accuracy of statistical procedures in Microsoft Excel 2003
• On the accuracy of statistical procedures in Microsoft Excel 2007
• On the accuracy of statistical procedures in Microsoft Excel 97.
• Teaching statistics with Excel 2007 and other spreadsheets
• The accuracy of statistical distributions in Microsoft\(^{\circledR}\) Excel 2007

Cited in

(2)

• It's easy to produce Chartjunk using Microsoft\(^{\circledR}\) Excel 2007 but hard to make good graphs
• On the accuracy of statistical procedures in Microsoft Excel 2010

Describes a project that uses

Uses Software

• Excel

This page was built for publication: Polynomial trendline function flaws in Microsoft Excel

Report a bug (only for logged in users!)Click here to report a bug for this page (MaRDI item Q962373)