Incorrect Nonlinear Trend Curves in Excel
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
Year of publication: |
2006
|
---|---|
Authors: | Hesse, Rick |
Published in: |
Foresight: The International Journal of Applied Forecasting. - International Institute of Forecasters - IIF. - 2006, 3, p. 39-43
|
Publisher: |
International Institute of Forecasters - IIF |
Saved in:
Online Resource
Saved in favorites
Similar items by person
-
How electronic spreadsheets changed the world
Hesse, Rick, (2009)
-
A heuristic search procedure for estimating a global solution of nonconvex programming problems
Hesse, Rick, (1973)
-
Portfolio performance with inverse and leveraged ETFs
DiLellio, James A., (2014)
- More ...