Incorrect Nonlinear Trend Curves in Excel

Rick Hesse,

Foresight: The International Journal of Applied Forecasting, 2006, issue 3, 39-43

Abstract: Many software programs, including Excel, make it easy to fit exponential trends (that is compound interest growth) to time series data. However, with Excel and some other products, there is a big problem: the exponential functions are done incorrectly because they use logarithmic transformations. Rick illustrates the right way to fit exponential trends, and he shows how misleading the Excel procedure can be. Copyright International Institute of Forecasters, 2005

Date: 2006
References: Add references at CitEc
Citations: View citations in EconPapers (2)

Downloads: (external link)
https://foresight.forecasters.org/shop/

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:for:ijafaa:y:2006:i:3:p:39-43

Access Statistics for this article

More articles in Foresight: The International Journal of Applied Forecasting from International Institute of Forecasters Contact information at EDIRC.
Bibliographic data for series maintained by Michael Gilliland ().