Polynomial Trendline function flaws in Microsoft Excel

Computational Statistics and Data Analysis

Volumn 54, Issue 4, 2010, Pages 1190-1196

  Hargreaves, Bruce R ^a   McWilliams, Thomas P ^b  

^a LEHIGH UNIVERSITY   (United States)

^b DREXEL UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

GENERATING POLYNOMIAL; MICROSOFT EXCEL; SIGNIFICANT DIGITS;

POLYNOMIALS;

SPREADSHEETS;

EID: 73149113051     PISSN: 01679473     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.csda.2009.10.020     Document Type: Article

References (14)

1. Hesse R. Incorrect nonlinear trend curves in Excel. Foresight: International Journal of Applied Forecasting 3 (2006) 39-43
2. Kutner M., Nachtsheim C., Neter J., and Li W. Applied Linear Statistical Models. 5th ed (2005), McGraw-Hill Irwin, New York
3. McCullough B.D. Is is safe to assume that software is accurate?. International Journal of Forecasting 16 (2000) 349-357
4. McCullough B.D. Microsoft Excel's 'not the Wichmann-Hill' random number generators. Computational Statistics and Data Analysis 52 10 (2008) 4587-4593
5. McCullough B.D. Editorial: Special section on Microsoft Excel 2007. Computational Statistics and Data Analysis 52 1 (2008) 4568-4569
6. McCullough B.D., and Heiser D.A. On the accuracy of statistical procedures in Microsoft Excel 2007. Computational Statistics and Data Analysis 52 10 (2008) 4570-4578
7. McCullough B.D., and Wilson B. On the accuracy of statistical procedures in Microsoft Excel 97. Computational Statistics and Data Analysis 31 (1999) 27-37
8. McCullough B.D., and Wilson B. On the accuracy of statistical procedures in Microsoft Excel 2000 and XP. Computational Statistics and Data Analysis 40 4 (2002) 27-37
9. McCullough B.D., and Wilson B. On the accuracy of statistical procedures in Microsoft Excel 2003. Computational Statistics and Data Analysis 49 4 (2005) 1244-1252
10. Nash J. Teaching statistics with excel 2007 and other spreadsheets. Computational Statistics and Data Analysis 52 10 (2008) 4602-4606
11. Pottel, Hans, 2003. Statistical Flaws in Excel, Mimeo, Innogenetics NV, Zwijnaarde Belgium
12. Su Y.-S. It's easy to produce chartjunk using Microsoft Excel 2007 but hard to make good graphs. Computational Statistics and Data Analysis 52 10 (2008) 4594-4601
13. Yalta A., and Talha. The accuracy of statistical distributions in Microsoft Excel 2007. Computational Statistics and Data Analysis 52 10 (2008) 4579-4586
14. Yalta A.T., and Jenal O. On the importance of verifying forecasting results. International Journal of Forecasting 25 1 (2008) 62-73