Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Accessing values in exponential trendline equation
446 views
Skip to first unread message
jstansbury
Aug 13, 2004, 5:29:01 PM8/13/04
to
Hi,
I need to access the calculated values in the equation for an expontial
trendline. I'd rather not have to create a chart and trendline and then
manually enter the values. I know how to get the slope and intercept via
functions, but need the "a" and "b" values from y = ae^bx. Any tips or help
very much appreciated.
Thanks,
j
I need to access the calculated values in the equation for an expontial
trendline. I'd rather not have to create a chart and trendline and then
manually enter the values. I know how to get the slope and intercept via
functions, but need the "a" and "b" values from y = ae^bx. Any tips or help
very much appreciated.
Thanks,
j
Jerry W. Lewis
Aug 13, 2004, 11:34:10 PM8/13/04
to
y = a*e^(b*x)
is equivalent to
ln(y) = ln(a) + b*x
You can then use SLOPE() and INTERCEPT() to get b and ln(a). This is
equivalent to what is done when you fit the chart exponential trendline.
is equivalent to
ln(y) = ln(a) + b*x
You can then use SLOPE() and INTERCEPT() to get b and ln(a). This is
equivalent to what is done when you fit the chart exponential trendline.
Jerry
Yelverton@discussions.microsoft.com K Yelverton
Sep 8, 2004, 11:07:08 PM9/8/04
to
Is there a similar way to work a mulitple order polynomial trendline equation?
Jon Peltier
Sep 8, 2004, 11:41:27 PM9/8/04
to
Bernard Liengme has an example worked out for you:
http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Jerry W. Lewis
Sep 9, 2004, 7:13:20 AM9/9/04
to
LINEST in some cases can be subject to numerical difficulties. The
safest course is to request a chart polynomial trendline and verify that
the coefficients are consistent with those given by LINEST.
Interestingly, the chart polynomial trendline (formatted to display full
precision) is better than almost all dedicated statistics packages.
Alternately, David Braden has posted VBA code to extract the
coefficients directly from the chart into cells
safest course is to request a chart polynomial trendline and verify that
the coefficients are consistent with those given by LINEST.
Interestingly, the chart polynomial trendline (formatted to display full
precision) is better than almost all dedicated statistics packages.
Alternately, David Braden has posted VBA code to extract the
coefficients directly from the chart into cells
http://groups.google.com/groups?selm=dbraden-1C662A.14054705032003%40msnews.microsoft.com
Jerry
0 new messages