By the way, can you use a dynamic range name for the Xrange & Yrange? I can't
seem to get it to work. I keep getting a #NAME? error

Mike Middleton wrote:
Carrie -

Using Excel 2003 SP3, I get the same results as Power trendline when I use
these worksheet formulas:

=SLOPE(LN(Yrange),LN(Xrange))
=EXP(INTERCEPT(LN(Yrange),LN(Xrange)))
=RSQ(LN(Yrange),LN(Xrange))

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

OK - Still stuck - tried several LINEST formuals and CORREL(LN(y),x) none
of
[quoted text clipped - 22 lines]
Thank you in advance for any asssistance.
Carrie

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200808/1