Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Fitting a power or exponential trendline
3 views
Skip to first unread message
Daniel
Apr 1, 2004, 12:53:20 AM4/1/04
to
How do I fit a power or exponential trendline to a data
series in a chart? I only have the options of linear and
polynomial trendlines.
series in a chart? I only have the options of linear and
polynomial trendlines.
Arto Huttunen
Apr 1, 2004, 2:28:23 AM4/1/04
to
"Daniel" <anon...@discussions.microsoft.com> wrote in message
news:1698c01c417ad$a3132b20$a501...@phx.gbl...
> How do I fit a power or exponential trendline to a data
> series in a chart? I only have the options of linear and
> polynomial trendlines.
Y = exp( a * X) ===> log(Y) = a * X
Jerry W. Lewis
Apr 1, 2004, 7:13:04 AM4/1/04
to
Chart|Add Trendline and select the type of model that you want.
Jerry
Michael R Middleton
Apr 1, 2004, 5:22:55 PM4/1/04
to
Daniel -
> How do I fit a power or exponential trendline to a data series in a chart?
I only have the options of linear and polynomial trendlines. <
Excel uses transformations to fit power and exponential, and if the original
data has negative values those options are greyed out.
A workaround is to add a constant to the original data so that all values
are positive.
- Mike Middleton, www.usfca.edu/~middleton
0 new messages