see the website
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
for how to use LINEST for linear, polynomial, log, power, and exponential equations.

Power:
y = ax^b
=LINEST(LN(y-values), LN(x-values))
Gives Ln(a) and b


On Monday, November 02, 2009 5:23 PM newby wrote:

can use LINEST for linear trendlines, LOGEST for Exp. trendlines, but Icannot
see how to get values for Power series trendlines. Anybody help