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


"Carrie_Loos via OfficeKB.com" <u34134@uwe wrote in message
news:88300cd362c45@uwe...
OK - Still stuck - tried several LINEST formuals and CORREL(LN(y),x) none
of
which gave me the same answer. Do you know a formula that will work?

Mike Middleton wrote:
Carrie -

For formulas, see John Walkenbach's summary:

http://www.j-walk.com/ss/excel/tips/tip101.htm

His formulas for the Power trendline use the array-entered LINEST
function,
but you could use the standard SLOPE and INTERCEPT functions, instead.

For the Power trendline, Excel transforms both the Y and X values before
using a linear fit, so the RSQ results are for fitted Log(Y).

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

Hi -

[quoted text clipped - 14 lines]
Thank you in advance for any asssistance.
Carrie

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