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