Journal article
Polynomial Trendline function flaws in Microsoft Excel
Computational statistics & data analysis, v 54(4), pp 1190-1196
01 Apr 2010
Featured in Collection : UN Sustainable Development Goals @ Drexel
Abstract
Numerous statistical and graphical problems have been reported for different versions of Microsoft Excel, including the newest version (Excel 2007). We report newly discovered problems with Excel 2007 when generating polynomial trend line equations, having a user-specified (forced) intercept, from graphed data. We also remind users of Excel's Trendline function of problems with Excel 2003 that have not been corrected in Excel 2007. Excel will "fit" nonsense trend lines to data presented on column and line charts, and can report an inadequate number of significant digits for polynomial trend lines. We provide suggestions for avoiding these continuing problems, but are unable to identify an Excel 2007 workaround solution for the forced-intercept polynomial trend line errors. (C) 2009 Elsevier B.V. All rights reserved.
Metrics
Details
- Title
- Polynomial Trendline function flaws in Microsoft Excel
- Creators
- Bruce R. Hargreaves - Lehigh UniversityThomas P. McWilliams - Drexel University
- Publication Details
- Computational statistics & data analysis, v 54(4), pp 1190-1196
- Publisher
- Elsevier
- Number of pages
- 7
- Resource Type
- Journal article
- Language
- English
- Academic Unit
- [Retired Faculty]
- Web of Science ID
- WOS:000274574600035
- Scopus ID
- 2-s2.0-73149113051
- Other Identifier
- 991019167712604721
UN Sustainable Development Goals (SDGs)
This publication has contributed to the advancement of the following goals:
InCites Highlights
Data related to this publication, from InCites Benchmarking & Analytics tool:
- Collaboration types
- Domestic collaboration
- Web of Science research areas
- Computer Science, Interdisciplinary Applications
- Statistics & Probability